Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I use the slicers year and month.
The "Actual" table shows the sales from 2019 to 2022 (as selected in the year slicer) for month January (as selected in the month slicer).
The "Desired Result" table shows the sales of the current year (=2022) for the selected month in the month slicer (=January) for each year selected in the year slicer (= 2019 to 2022). The result should be dynamic based on the month slicer. For example, when I select February in the month slicer, each column should show the sales of the current year (=2022) and February.
What DAX formula can I use to achieve the "Desired Result" table? I want to use it for further percentage calculation.
We can use the measure [Sales] for DAX.
Solved! Go to Solution.
You will want to try using the "ALLSELECTED()" function to ignore the additional year columns.
-
CY & CM =
You will want to try using the "ALLSELECTED()" function to ignore the additional year columns.
-
CY & CM =