Difference between years

okat
Posts: 5
Joined: Tue Apr 18, 2017 4:04 am

Difference between years

Postby okat » Tue Apr 18, 2017 4:44 am

I have an annual series of data over a period of 10 years and I would like to know the differences from one year to another. How could you implement this in power query?
Regards.
Attachments
Difference Sales.xlsx
(31.08 KiB) Downloaded 11 times

MattAllington
Posts: 816
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Difference between years

Postby MattAllington » Tue Apr 18, 2017 6:16 am

In power query
1 first add. Ayear column
2 group by year
3. Then use the technique similar to what I blogged about here to place the prior year in it's own column. https://powerpivotpro.com/2017/01/conve ... aily-data/
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest