Questions tagged [calculated-columns]
A calculated column is calculated from an expression that can use other columns in the same table
calculated-columns
2,300
questions
0
votes
3
answers
30
views
I want DAX calculated column in Power BI with following requirements
I have table with column A having repeated reference and column B status with text value G1, G2, G3, G4 and G5 which might be assigned to distinct reference with multiple statuses like as below.
I ...
0
votes
0
answers
28
views
MS Access: Caluclating Underlying Values from a Multi-Value Field [closed]
I have a Member Database (MS Access) that tracks diet preferences. My table includes a multi-value field for each food group. Each food type has associated points, like the following:
Vegetables
...
0
votes
3
answers
54
views
How to return multiple columns based on lowest score in table a, and join to flag eligibility in table b
I am wanting to return for each customer, the column names for the lowest 2 scoring products from Table A but only where the customer is eligible for that product which is indicated in Table B by a 1 ...
-2
votes
0
answers
33
views
problem in delete function in java and mysql [closed]
error message when i press delete حذف
I have a table connected with mysql when I choose a row to delete it doesn't work
here is the code of delete
private void l2MouseClicked(java.awt.event....
0
votes
1
answer
29
views
Find the first occurrence by date of a value from a list of values for each ID in a table
I have a table of data from Azure DevOps that contains a sequence of status changes for work items. Each record contains an ID for the work item, a status, a date at which the status changed and a ...
0
votes
1
answer
18
views
Joining and standardizing Country names in Tableau from different sources
I am calculating some metrics and need to standardize Country names on all sides in order to calculate it on a country level.
I have a transaction file consisting of two sql queries and external excel ...
1
vote
1
answer
55
views
What's the best way to calculate the weekday?
I have time series data with a TEXT timestamp formatted as DD.MM.YYYY HH:mm:ss.sss (.sss = ms).
I extract each component from the TEXT timestamp field and compose an ISO formatted timestamp as YYYY-MM-...
1
vote
1
answer
30
views
Add a column and fill with the value calculated using values from other columns
I am a newer in R. I want to add a column 'GFR' to the dataframe, and fill the column with the values calculated using GFR = 175 ✖️ (SCR^-1.154) ✖️ (age^-0.203) ✖️ 1.212[if Race = 3] ✖️ 0.742[if ...
-3
votes
1
answer
27
views
Change a number from a column to words in a different calculated column in dataverse tables
Is there a way to change a number from a column to words in a different calculated column in dataverse tables?
for example 100 to one hundred; 2,345 to two thousand three hundred forty five.
could not ...
0
votes
0
answers
20
views
Avoiding Circular Dependency when Calculating Inventory Projection
I am soliciting forecast feedback from users for a product/location/futuredate combination and am trying to merge this feedback with an replenishment table to be able to show a monthly projected ...
1
vote
0
answers
46
views
Calculated table from 2 tables and sum DAX
Im trying to create a calculated table from 2 tables that are connected with a bridge.
My 3 tables
Report ReportRow Account Sign UniqueKey
Rapport129 129/* CM 35100 1 4177960
...
0
votes
2
answers
137
views
Using column group subtotal in calculated field formula
I am pulling data into a Table in Excel using Power Query and then presenting this in a Pivot Table.
The Pivot Table has one field included in the "Columns" area, causing distinct values in ...
0
votes
2
answers
103
views
Sorting by calculated field
I have a ADOStoredProc component bound to a DBGrid. In addition to the columns from the stored procedure, a calculated field has been created in Delphi.
Now there I need to implement sorting of the ...
0
votes
2
answers
96
views
SQL Issue: calculated query column won't recognize day interval in DateDiff?
For some reason I can't get my calculated query column to recognize a day interval. Every time I test run the form that displays the query results, a parameter pop-up asks me to enter the value of d.
...
0
votes
0
answers
41
views
Power BI cumulative failure rate calculation
I am trying to create cumulative failure rate which is calculated as running total failures divide by running total claims.
I have a vehicle details table and claims table. Vehicle table is connected ...