Forum Discussion
Default current Year
I have a table called Sales and Calender. When the year is selected from the slicer it should show the selected year values, if not should show the default current year. For example, if I select 20...
Thank you Anthony,
Here is the DAX quey.
Selected Year =
IF (
ISFILTERED (Calender[date_id].[Year]),
YEAR(DATE(MAX(Calender[date_id].[YEAR]),1, 1)),
YEAR(TODAY())
)
I use this DAX, it was wroking fine but now its not working. Here is the screenshoot.
So what should it be showing?