topic DATESMTD IS NOT WOKING AS EXPECTED in DAX Commands and Tips

DATESMTD IS NOT WOKING AS EXPECTED

aswathyjoe — Wed, 18 Jan 2023 20:09:26 GMT

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 ?

AnthonyJoseph — Wed, 18 Jan 2023 19:56:09 GMT

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 — Wed, 18 Jan 2023 19:58:14 GMT

Hi Anthony, Thnaks for the reply.

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

HotChilli — Thu, 19 Jan 2023 00:47:59 GMT

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?