-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 23-
(Excel formulas also welcome for Power Query Challenges)
Generate the resultant table.
Yearly Month on Month Sales Difference is difference in sales for one year - previous year for same month
For example = 2018 Feb Sales - 2017 Feb Sales
Yearly Quarter on Quarter Sales Difference is difference in sales for one year - previous year for same quarter
For example = 2018 Q1 Sales - 2017 Q1 Sales
Download Practice File - https://lnkd.in/dKdvq8xU
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge
Excel BI’s LinkedIn Post