topic Re: Monthly cumulative running total continuation in DAX Commands and Tips

Monthly cumulative running total continuation

dmc2020 — Mon, 17 Jun 2024 09:29:44 GMT

I am trying to figure out a measure to calulcate how many to date are "currenlty open overdue" e.g June should be showing 11 open overdue by including and calculating all the previous months that are still open overdue. Need the line to show whether the total open overdue is getting better or worse each month.

This is the measure i have just now but it's only calculating for that month and not including previous.

OpenAndOverdueCount =

IF(

ISBLANK(

CALCULATE(

COUNTROWS('Merged Deviations'),

'Merged Deviations'[Status] = "open",

'Merged Deviations'[Upcoming Days] > 0

)

CALCULATE(

COUNTROWS('Merged Deviations'),

'Merged Deviations'[Status] = "open",

'Merged Deviations'[Upcoming Days] > 0

)

Re: Monthly cumulative running total continuation

amitchandak — Mon, 17 Jun 2024 09:37:19 GMT

dmc2020 , Hope you are using date table joined with date of your table

OpenAndOverdueCount = = CALCULATE(
COUNTROWS('Merged Deviations'),
'Merged Deviations'[Status] = "open",
'Merged Deviations'[Upcoming Days] > 0
)

OpenAndOverdueCount Cumm = calculate([OpenAndOverdueCount], filter(Date, Date[Date] <= Max(Date[Date])) )

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.