Forum Discussion
PSB
Helper III
Helper IIIrolling 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 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 |
Hi,
PBI file attached.
Hope this helps.
5 Replies
- Ashish_Mathur
Super User
Hi,
This shoud typically be done with a measure (not in Power Query). Would you be OK with that?
PSBYes, that will work too. Would you please share pbix file with solution?
Thanks
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.