DAX - DATEADD Function

dhamodarankms , dateadd work with continuous dates. Means you need to have date in your date table for that. Make sure you have all dates in date table.

 You can also use date for day, month and year as date add

example

Today = TODAY()
Month Back Date = Var _DT = Today() 
return Date(year(_DT),Month(_DT)-1,Day(_DT))

Year, Month, day Back Date = Var _DT = Today() 
return Date(year(_DT)-1,Month(_DT)-10,Day(_DT)-1)

 

 

refer

https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827

dhamodarankms You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

 

Specifically maybe this: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-DATEADD/m-p/1259467#M583

If you navigate to dax.guide/dateadd/, you'll find that one of the sentences in the description of the function says:

The result table includes only dates that exist in the dates column.

Does this explain the behaviour you see?

Hello dhamodarankms ,

 

DATEADD function requires a date table which should include all the days within one year. A complete date table is of great importance for DATEADD to behave as expected.

 

DATEADD function uses three rules:

1. It only returns days that exists in the date column. If some expected dates are missing, then it returns only those dates that are not missing in the date column
2. If a date does not exist in the corresponding month after the shifting operation, then the result of DATEADD includes the last day of the corresponding month.
3. If the selection includes the last two days of a month, then the result of DATEADD includes all the days between the corresponding days in the shifted month and the end of the shifted month.

 Alternatively, you can use PARALLELPERIOD.

 

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter