Forum Discussion
AlbLS
7 years agoFrequent Visitor
Running Total per Month from a Measure
Hello everyone, I am new to the Power BI community. Thank you in advance for your help. I have a problem with a cummulative calculation from a measure. This calculation works perfectly for the year...
- 7 years ago
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.
AlbLS
7 years agoFrequent Visitor
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
Ashish_Mathur
7 years agoSuper User
You are welcome. If my reply helped, please mark it as Answer.