Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
5 months ago
Solved

Running Sum Max Date

Hi good day can anyone help me on my visual calcualtion.  I used running sum and i need result up to the Max date only on my other table. The 3/18 onward should be blank.

Thank you

Need Help

4 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    5 months ago

    Hi AllanBerces , 

    If you use visual calculation then it'll calculate untill the last row, if you want to achieve the sum only until where the last record exists for daily earned then you need to create a separate DAX measure.

     

    To achive this first 

    Capture Max Date Measure:-

    Max Earned Date =
    CALCULATE(
    MAX('Table'[Date]),
    FILTER(
    ALL('Table'),
    NOT(ISBLANK('Table'[DailyEarned]))
    )
    )

     

    Then use it in below DAX

     

    Max Earned Date =
    CALCULATE(
    MAX('Table'[Date]),
    FILTER(
    ALL('Table'),
    NOT(ISBLANK('Table'[DailyEarned]))
    )
    )

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • danextian's avatar
    danextian
    Super User
    5 months ago

    Hi AllanBerces 

     

    Add Max Date to the visual and reference that in the running sum formula. Hide Max Date