How to display a 30 day count of values on a daily basis on a line chart in Power BI.

[sam95]

I've got the folllowing DAX measure, where I am trying to calculate the number of "Completed" treatments for a 30 day period.

Test Measure =

CALCULATE (COUNTROWS(FILTER(Treatments,

Treatments [Treatment Status] = "Completed")),

Treatments[Treatment Date] >= Treatments[Treatment Date] - 30)

Then I create a line chart, where I select my Test Measure and the date from a calendar table (I want to show this value on a daily basis)

But what the graph is showing, is the number of Completed treatments on a daily basis, what I want to do is for it to show me on a daily basis the number of "Completed" treatments for 30 days. How can I achieve this?

[Syk]

It sounds like you want a running total.. I'd recommend watching this 7 minute video - dax code around 4 minutes in if you want to skip straight to it!

https://www.youtube.com/watch?v=fR0dI5UfZD8