DATEADD returning Blank values

SalSal — Wed, 08 Jun 2022 03:47:44 GMT

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

Re: DATEADD returning Blank values

Anonymous — Mon, 13 Jun 2022 01:49:06 GMT

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

topic DATEADD returning Blank values in DAX Commands and Tips

DATEADD returning Blank values

Re: DATEADD returning Blank values