Date Table is Not Being Recognized

[Heather_W_876]

Your input is appreciated. 

My DIM_DATE table is set as my date table with the following relationship:

all of my date fields are formatted as M/D/YYYY

My issue is that when I try to use the DIM_DATE table in my DAX formulas, it is not being recognized:

MTD = TOTALMTD(sum(Report_W_Period[Amount]),DIM_Date[Date])

MTD PY = CALCULATE(TOTALMTD(sum(Report_W_Period[Amount]),DIM_Date[Date]),SAMEPERIODLASTYEAR(DIM_Date[Date]))

Any assistance is appreciated.

Rae

[littlemojopuppy]

Hi @Heather_W_876 ...silly question: did you mark it as a date table?  Right click on the table and make sure "mark as date table" is checked

[Heather_W_876]

I did verify it is marked as a date table.

[littlemojopuppy]

Hi @Heather_W_876 can you provide a sample pbix to play with?