cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThunderRoad Frequent Visitor
Frequent Visitor

Several 7 day Moving Average

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: 

 

Capture3.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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. 

4 REPLIES 4
Super User
Super User

Re: Several 7 day Moving Average

is this what you are looking for?

 

zone.PNG






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





ThunderRoad Frequent Visitor
Frequent Visitor

Re: Several 7 day Moving Average

Yes, something like that. Could you share the solution please? : )

Super User
Super User

Re: Several 7 day Moving Average

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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





ThunderRoad Frequent Visitor
Frequent Visitor

Re: Several 7 day Moving Average

But that is not the moving average, that is just plotting the values, right?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 140 members 1,557 guests
Please welcome our newest community members: