Forum Discussion
Solved
rolling 7 days Median trend (Power Query)
I have data with Date and Data field. I need rolling 7 days median chart. for each day, I need what was past 7 days median. X-Axix (date), Y-Axis (Median value for past 7 days) there are multiple ...
Hi,
PBI file attached.
Hope this helps.
Hi,
This shoud typically be done with a measure (not in Power Query). Would you be OK with that?
Yes, that will work too. Would you please share pbix file with solution?
Thanks
Hi,
PBI file attached.
Hope this helps.
Really appreciate your help. This solution worked for me.
