Difference between years

Posts: 16
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 95 times

Posts: 983
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 Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests