Eileen McCarthy
Active Member
Members
Forum Posts: 5
Member Since:
October 22, 2021
October 22, 2021
Offline
I am trying to Calculate Year on year difference and % for each month in Power Query rather than Power BI. So Jan 2018 V Jan 2019 should be 3680060-3347464 = 332596 and 9%. Thanks Eileen
Alan Sidman
Steamboat Springs, CO
Member
Members
Trusted Members
Trusted Members
Forum Posts: 193
Member Since:
October 18, 2018
October 18, 2018
Offline
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi Eileen,
Power query isn't the right place to do a calculation like this.
If you're using Power BI then you need to write measures that use the DAX time intelligence functions.
If you're using Excel then you can do it with a PivotTable, as Alan illustrated. There are no 'calculations' to give as such, because it's done by the PivotTable as explained in this PivotTable Month on Month Calculation tutorial.
Mynda
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Wendy Rankin, Amanda Zibell
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —