Forum Discussion

Joe_Grosskopf's avatar
Joe_Grosskopf
Icon for Helper II rankHelper II
4 years ago

Need to understand running totals

I'm trying to create a running total column but can't seem to figure it out based on the examples I find online. Can anyone show me the breakdown of the command? ie RT = calculate([column1], [column2...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Joe_Grosskopf Spaces. VAR is a DAX key word/function:

Total_RT =
            VAR __date = max('Dept_Total_Hours'[Total])
            VAR __Table = FILTER(ALLSELECTED((Dept_Total_Hours),Dept_Total_Hours[DATE_PERFORMED] <= __Date
        return
            sumx(__table,[Value])

So "VAR " then you provide the variable name like "__Date" and then an equals sign (=) and then your DAX code.

Joe_Grosskopf's avatar
Joe_Grosskopf
Icon for Helper II rankHelper II
4 years ago

Greg_Deckler I believe I have it working now...Thank you so much!