I can’t find a formula which calculates the difference % between 2 columns in my pivot table using Power Pivot.
See Data in data model:
enter image description here
See Pivot table:
enter image description here
I want to calculate the sum of sales for week 1 in 2024 against the sum of sales for week 1 in 2023 and get the difference %. So in the pivot table above I want to add a column after each week which shows the difference % between the 2 weeks for each week up to week 52.
In a normal Pivot table I would create a calculated field and choose Difference % from.
See below:
enter image description here
How can I recreate this using a Dax formula?
Ingenious1 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.