Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need assistance with a formula for running total. I am using the formula below, but as you can see from the screenshot, the running total is not being calculated. What am I doing wrong?
RT_BUD_CL = TOTALYTD ( SUM('Summary Query'[BUD CL]), 'Summary Query'[DATE].[Date] )
'Summary Query'[BUD CL] is the value column
'Summary Query'[DATE] is the date column
Solved! Go to Solution.
@Seth_OttoBros, What an annual total and measure
Total measurement running with date table
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-maxx(date,date[date])))
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-max('Summary Query'[DATE])))
Como una nueva columna
Cumm á CALCULATE(SUM('Summary Query'[BUD CL]),filter('Summary Query','Summary Query'[DATE] <-earlier('Summary Query'[DATE] )))
To get the best out of the time intelligence function. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of your events. See :radacad sqlbi My Video Series Appreciate your congratulations.
@Seth_OttoBros, What an annual total and measure
Total measurement running with date table
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-maxx(date,date[date])))
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-max('Summary Query'[DATE])))
Como una nueva columna
Cumm á CALCULATE(SUM('Summary Query'[BUD CL]),filter('Summary Query','Summary Query'[DATE] <-earlier('Summary Query'[DATE] )))
To get the best out of the time intelligence function. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of your events. See :radacad sqlbi My Video Series Appreciate your congratulations.
Thanks Amit, works perfectly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |