Forum Discussion
DATEADD returning Blank values
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
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
1 Reply
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