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[Date]),"Type","MTD")
 
as shown in the picture, I have the date 1/1/2023 for this month in the date dimension table.
 
 
but my new table is giving me a differnet date in 2024. please see the undelined date above.

 

 

What am I doing wrong here. Can anyone help ?

My date dimension contains dates until 2024. is it because of that I am getting MTD date as different ?

How can I get the MTD based on the current month ?

 
 

 

3 Replies

  • 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

       

       

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    3 years ago

    I'm a bit confused as to what you're trying to do and what is stated in the original post.

    Have you created a one row table and you don't know where it comes from?  It's probably the last date in the dim_date table.

    --

    What is it you are trying to do?  Can you post some sample data and the desired result please?