Forum Discussion

AlbLS's avatar
AlbLS
Frequent Visitor
7 years ago
Solved

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    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.
    Mariusz Repczynski

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

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.

AlbLS's avatar
AlbLS
Frequent Visitor
7 years ago

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's avatar
    Ashish_Mathur
    Super User
    7 years ago

    You are welcome.  If my reply helped, please mark it as Answer.