POWER PIVOT – Distinct values based on boolean measure
I have a table like
Point of sales Employee Category Answer Supervisor Date
POS35 Emp6 Wine 2 SV3 07.05.2024
POS70 Emp13 Cognac 1 SV1 17.05.2024
POS237 Emp1 Wine 1 SV1 31.05.2024
POS171 Emp9 Wine 1 SV1 17.05.2024
POS20 Emp20 Cognac 0 SV1 09.05.2024
POS160 Emp20 Wine 2 SV1 31.05.2024
POS117 Emp13 Wine 0 SV1 20.05.2024
POS241 Emp3 Cognac 0 SV1 01.05.2024
POS163 Emp6 Cognac 0 SV3 20.05.2024
POS41 Emp12 Cognac 1 SV3 05.05.2024
POS138 Emp17 Cognac 1 SV1 16.05.2024
Difference % between 2 columns in Pivot table using Dax measure within Power Pivot
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.