DATESMTD IS NOT WOKING AS EXPECTED

[aswathyjoe]

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 ?

[HotChilli]

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?

[AnthonyJoseph]

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]

Hi Anthony, Thnaks for the reply.

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