Year Slicer

[anjcampo]

Hi Can someone know how to create A Dax measure to year slicer using 3 date columns in different table (3 table), the matrix is showing month values and I would like to have the 1 (Year) slicer visual for the 3 matrix visuals. Thank you.

[Fowmy]

@anjcampo 

Create a dates table and connect (using relationship) it to those three tables, then you will be able to use the Year column on the slicer to filter all the visuals.


Here is the code to create a dates table, chagne the date range as needed:

Dates = ADDCOLUMNS(
   CALENDAR("01/01/2022","31/12/2022"),
   "Month No" , MONTH([Date]),
   "Month Name" , FORMAT( [Date] , "Mmmm" ),
   "Year" , YEAR([Date]),
   "Month Year No" , (YEAR([Date]) * 100) + MONTH	([Date]),
   "Month Year" , FORMAT( [Date] , "Mmm yyyy"),
   "Quarter" , QUARTER([Date]),
   "Year Qtr" , FORMAT( [Date] , "YYYY \QQ"),
   "Week Day" , WEEKDAY([Date],2),
   "Week" , FORMAT( [Date] , "Dddd" )

)