Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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 |
Solved! Go to Solution.
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
Really appreciate your help. This solution worked for me.
You are welcome.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 38 | |
| 31 | |
| 27 |