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[...
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?