Date table and Matrix Confusion

[Riley-Byrne]

Hello BI Community!

I am running into a bit of confusion in the use of a date table, and how it affects a Matrix table of mine. 

When I leave my date table unmarked, my matrix table is able to have a date hieararchy when I use dates as columns. However, I would like the ability for my slicer to have the capabilities it does when it is a date table (such as relative dates). 

When I mark my date table as a date table, however, my matrix automatically undoes the hierarchy  in the date columns, and shows each day when I would like it to still show each month.

Does anyone know a solution to this? 

[v-lili6-msft]

hi, @Riley-Byrne 

You could use the date function to add calculate column in the table which is unmarked as date table

https://docs.microsoft.com/en-us/dax/date-and-time-functions-dax

Best Regards,

Lin

[parry2k · Accepted solution]

@Riley-Byrne you should add month and other columns in your date table and use those in your matrix.  here is more on date table.