Solved: cut off running total on visual at today - Page 2

Anonymous · ‎08-07-2019

I want my visual to cut off at "Today" and the way I am doing it with my measure it is not working. I dont want to use filters because Ill have to change that every month. Is there another way to do this?

RunningRev = 
CALCULATE(
    SUM(FinancialPlans[RevChange]),
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date]<= TODAY()
    )
)

parry2k · ‎08-07-2019

@Anonymous try following measure

RT =
VAR _S =
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        KEEPFILTERS ( 'Calendar'[Date] <= TODAY () )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER (
            ALL ( 'Calendar'[Date] ),
            'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
        )
    )
        * DIVIDE ( _S, _S )

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post