Hi, I know there are several threads about this already but I've read them all and I can't get the da*n Moving Average to work.
After some work I've come to some data like this:
These are different zones, the hours spent on some project in each zone and the date. Ideally, I'd like to get a line chart with the 7-day moving average of the time spent in each zone (so 4 different lines in the chart).
This is the dummy pbix: https://mega.nz/#!fMNkEZiR!BYWSyj6WG3eRqyrAHEDr-sDaBFcd4LXAYqlvVCQTtn0
I'd be very grateful if someone could help me : ) Have a nice day.
is this what you are looking for?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Go to query editor, select date column, right click and choose "Unpivot other columns"
you will get two more columns attribute and value, change column name attribute to "Zone"
Add line visual, date on axis, value column on value and zone on legend. that will do it.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
