Forum Discussion

Theamitbhardwaj's avatar
Theamitbhardwaj
Regular Visitor
5 years ago
Solved

DATEADD DAX FUNCTION

I am facing a challenge while using “DATEADD” DAX function. Below is the function I am using DATEADD('This Month'[Today].[Date],3,Month). Column “'This Month'[Today]” contain date as “21 oct 2020”,...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @Theamitbhardwaj , Dateadd requires a continuous date in the table. So if the date isn't present, it won't give the right answer

    you can use the date instead of dateadd as

    Add four months

    =

    var _date to today()

    Return

    date(year(_date), Month(_date)+4, day(_date))