Difference between years

Posts: 14
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?
Difference Sales.xlsx
(31.08 KiB) Downloaded 39 times

Posts: 919
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

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest