Forum Discussion
DAX Calculation - HELP
I have this summarized dataset grouped by multiple variables. This is a screenshot of a table I created from the dataset (other variables are being used as slicers), each index point has muli...
sjoerdvn
Solution Sage
Solution SageYou mean a running total?
RT 2023 = VAR mi=MAX(Append1'[Index]) RETURN CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 }, 'Append1'[Index] <= mi)
I should have cleared this ealier but the "Index" col is exactly not an index column. So I have a text field with 7 different values in it and I duplicated that col and just replaced those values with numeric values to able to sort them. And using the formula you provided I see it replicating the values
- sjoerdvn
Well, a column is column. What isn't clear from what you've shared so far is what table that column is on, so I assumed it was in the same table.
If that "Index" column is on some linked (dimension) table it would explain why the code I sent earlier doesn't work, you would have to change it to something like:RT 2023 = VAR mi=MAX(SomeDimensionTable[Index]) RETURN CALCULATE(SUM('Append1'[STARTS]), 'Append1'[COMPYEAR] IN { 2023 }, SomeDimensionTable[Index] <= mi)