Sales of Current Year and Selected Month in Each Column

TimmK — Wed, 06 Jul 2022 06:53:54 GMT

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.

Re: Sales of Current Year and Selected Month in Each Column

arichard19 — Wed, 06 Jul 2022 07:53:50 GMT

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)
-

topic Re: Sales of Current Year and Selected Month in Each Column in DAX Commands and Tips

Sales of Current Year and Selected Month in Each Column

Re: Sales of Current Year and Selected Month in Each Column