Forum Discussion

anjcampo's avatar
anjcampo
New Member
2 years ago

Year Slicer

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 visua...
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

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

)