Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Table is Not Being Recognized

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

 

3 Replies

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I did verify it is marked as a date table.