Forum Discussion

P567's avatar
P567
Regular Visitor
2 years ago

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...
Calculated Measures
DAX
PBI
MargusMartsepp's avatar
MargusMartsepp
New Member
2 years ago

You can create 2 separate running totals:

RunningTotal_2023 = 
VAR CurrentIndex = MAX('Table'[Index])
RETURN
CALCULATE(
    SUM('Table'[2023]),
    FILTER(
        ALL('Table'),
        'Table'[Index] <= CurrentIndex
    )
)

RunningTotal_2022 = 
VAR CurrentIndex = MAX('Table'[Index])
RETURN
CALCULATE(
    SUM('Table'[2022]),
    FILTER(
        ALL('Table'),
        'Table'[Index] <= CurrentIndex
    )
)

 

P567's avatar
P567
Regular Visitor
2 years ago

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