rolling 7 days Median trend (Power Query)

[PSB]

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 values for each day.

Date	Data
1/1/2021	0.1
1/1/2021	0.5
1/1/2021	0.9
1/2/2021	0.5
1/2/2021	0.6
1/2/2021	0.6
1/3/2021	0.1
1/3/2021	0.9
1/3/2021	1.8
1/4/2021	2.8
1/5/2021	3.8
1/6/2021	4.8
1/7/2021	5.8
1/8/2021	6.8
1/9/2021	7.8
1/10/2021	8.8
1/11/2021	9.8
1/12/2021	10.8
1/13/2021	11.8
1/14/2021	0.6
1/15/2021	0.1
1/16/2021	0.9
1/17/2021	1.8
1/18/2021	2.8
1/19/2021	17.8
1/20/2021	18.8
1/21/2021	19.8
1/22/2021	0.6
1/23/2021	0.1
1/24/2021	0.9
1/25/2021	1.8
1/26/2021	2.8
1/27/2021	25.8
1/28/2021	26.8

[Ashish_Mathur]

Hi,

This shoud typically be done with a measure (not in Power Query).  Would you be OK with that?

[PSB]

Yes, that will work too. Would you please share pbix file with solution?

 Thanks

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[PSB]

Really appreciate your help. This solution worked for me.

[Ashish_Mathur]

You are welcome.