Running Total by Period

[brockry1]

How do I create a measure using DAX to calculate the running total from the second column? 

[uzuntasgokberk · Accepted solution]

Hello @brockry1 ,

Could you try below dax code. But before creating dax code there is a need that a new column includes period such as 01,02 etc. I called PeriodIndex in dax code.

Running Total =
CALCULATE(
    SUM('Visits'[Visit Target Per Period]),
    FILTER(
        ALL('Visits'),
        'Visits'[PeriodIndex] <= MAX('Visits'[PeriodIndex])
    )
)

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |