Sales of Current Year and Selected Month in Each Column

[TimmK]

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.

[arichard19 · Accepted solution]

You will want to try using the "ALLSELECTED()" function to ignore the additional year columns.

-
CY & CM =

VAR CY = YEAR(TODAY())

Return

CALCULATE('Report Measures'[Realized Revenue], ALLSELECTED(Calender[Year]), Calender[Year] = CY)
-