Forum Discussion

aswathyjoe's avatar
aswathyjoe
Frequent Visitor
3 years ago

DATESMTD IS NOT WOKING AS EXPECTED

Hi I am building a new table called "Date Period" based on my date dimension table. Below shown is the dax I used to create the new table and columns. Date Period = ADDCOLUMNS(DATESMTD (Dim_Date[...
AnthonyJoseph's avatar
AnthonyJoseph
Icon for Resolver III rankResolver III
3 years ago

Hi aswathyjoe .MTD returns the value in Date/time format.  Can you try changing the data type of the column to be Date. 

 

Thanks,

AnthonyJoseph

  • aswathyjoe's avatar
    aswathyjoe
    Frequent Visitor
    3 years ago

     

    Hi Anthony, Thnaks for the reply.

    I tried changing it. please see below. its still giveing a date in 2024