topic Re: Power BI, Dax - Rolling 28 days measures date from my start date in DAX Commands and Tips

Power BI, Dax - Rolling 28 days measures date from my start date

Cattie — Thu, 11 Apr 2024 11:50:23 GMT

Hi,

Need to create a measure for rolling 28 days snapshot to be shown on visual like below graph

Rolling28 Days =

VAR StartDate_= Min(mydate)

VAR MyMeasure_= sum(Numerator)/sum(Denominator)---percentage

Return

CALCULATE(MYmeasure, StartDate_,+28, Max(mydate))

I dont know how to show the 28 days snapshot on viual as you see above

Many thanks for your help

Thanks , Cattie

Re: Power BI, Dax - Rolling 28 days measures date from my start date

Anonymous — Fri, 12 Apr 2024 01:29:04 GMT

Hi Cattie

Here's a refined version of your measure:

Rolling28Days = VAR EndDate = MAX(mydate) RETURN CALCULATE( SUM(Numerator) / SUM(Denominator), DATESINPERIOD( mydate, EndDate, -28, DAY ), ALLSELECTED(mydate) )

To visualize this as a rolling 28-day snapshot:

Ensure your date field is properly set up in the Power BI model with a continuous date range.
Add a line chart or any other time series visual to your report.
Drag your mydate field to the Axis area.
Drag the measure to the Values area.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI, Dax - Rolling 28 days measures date from my start date

Cattie — Sat, 13 Apr 2024 15:23:18 GMT

Hi Anonymous many thanks for your help and quick response. but I still have problem showing the specific date on visual, My date table starts from 18-12-203 and shows every day and I need to show this measure ever 28days(or 4 weeks) from start date which is 18-12-2023. when I pull the date on visual the measure is calcuated daily see below, which i dont want this, I need the date to beshown like above 18-12-23 , then 15 -01-204 then 12-02-2024 and etc. Hope this helps. Thank you

Re: Power BI, Dax - Rolling 28 days measures date from my start date

Anonymous — Thu, 18 Apr 2024 07:16:15 GMT

Hi Cattie

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.