DATEADD not giving month from last year

[Anonymous]

Following Date Add logic should return "Dec-2021" as value but giving no result, i am getting NULL in the field can anyone please help in this regard as my agging reports getting effected due to that.

DATEADD( Aging_label[today].[Date],-1,MONTH)

[v-rongtiep-msft]

Hi @Anonymous ,

Dateadd returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.

Do you want to return one column of data or one table？

I have create a sample data.Please have a try.

Create a measure.

Measure = EDATE(SELECTEDVALUE(Aging_label[today]),-1)

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[aj1973 · Accepted solution]

Hi @Anonymous 

In your formula  you are using  a date column from the fact table which might contain gaps in date. Time Intelligence functions like DATEADD work more efficiently with a Calendar Date Table. 

You need to add a Calendar date table to your model and link it to the fact table on date column, then use Calendar date column into your DAX formula.

[Anonymous]

JAN is current month and next should be ... one month before current month and next 2 month before current month.. was working fine in 2021 but after change in year creating problem

[ALLUREAN]

Is this date column? I mean that functions like DATEADD works only with date formatted field

[Anonymous]

yes this is date column

[ALLUREAN]

There is something that is not clear, to our side, share the full calculation measure, maybe the date column is not complete or data model. There can be a lot of reasons why not working

[ALLUREAN]

Hi, @Anonymous 

Try to remove .[Date]

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

[Anonymous]

tried same results

[ALLUREAN]

Can you share some examples of your data (sample)?