DATEADD returning Blank values

[SalSal]

Hi,

I'm trying to get the result of the DateAdd into number of months , for some of the records its working fine but for some records its returning blank. What I'm doing wrong here?

DATEADD(Table1[Date Completed].[Date], Table2[Test], MONTH)

Date Completed = '8/24/2020 10:00:00 AM'

Test = 24

Thanks,

-Sal

[v-yiruan-msft · Accepted solution]

Hi  @SalSal ,

In order to give you a suitable solution, could you please provide some sample data in the table Table1 and Table2(exclude sensitive data) with Text format and your expected result with backend logic and special examples? Please also share the relationship info if there is any relationship exist between these two tables. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

In addition, The following links describes some application scenarios of the DATEADD function, you can refer them.

Using The DATEADD Function For Effective Time Related Insights - Power BI

Issue with DATEADD function in DAX

Power BI Time Intelligence — DATEADD/SAMEPERIODLASTYEAR/PARALLELPERIOD

Best Regards