Difference between years

okat
Posts: 15
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 65 times

MattAllington
Posts: 934
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".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest

cron