Forum Discussion
Running Total per Month from a Measure
Hi AlbLS
I've simplified this for you, hope its what you need.# Entries = COUNTROWS( Entries )
# Departures = COUNTROWS( Departures )
# Difference = [# Entries] - [# Departures]
# Difference Running Total = IF( NOT ISEMPTY( Departures ) || NOT ISEMPTY( Entries ), CALCULATE( [# Difference], FILTER( ALL( 'Date' ), 'Date'[Date] <= MAX( 'Date'[Date] ) ) ) )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi Ashish,
Thank you very much for your answer and for your power bi file.
Unfortunately it does not solve my problem either, I already had the same result as you, but when the year changes, running totoal starts from scratch, and this is a mistake.
What I need is a graph like this:
when I'm going to filter for the year 2017, i will get this:
and filter for the year 2018, this:
I hope we can find the solution, for the moment I can not do it.
Thank you very much again.
Alberto
Hi,
Change the New Joinees YTD measure to:
Net joinees YTD = CALCULATE([Net joinees],DATESBETWEEN('Date'[Date],MINX(ALL('Date'),'Date'[Date]),MAX('Date'[Date])))
Hope this helps.
Thank you Ashish.
Your solution also works. It is different from that of Mariuzs, but it also works.
This could help other users!
Thank you so much!
Alberto
You are welcome. If my reply helped, please mark it as Answer.