DAX - DATEADD Function

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