topic Re: Facing issue while DATEADD(Merge_HR_TSR[Date Completed].[Date], Merge_HR_TSR[RiskTest], MONTHS) in DAX Commands and Tips

Facing issue while DATEADD(Merge_HR_TSR[Date Completed].[Date], Merge_HR_TSR[RiskTest], MONTHS)

Anonymous — Wed, 08 Jun 2022 08:01:03 GMT

Hi Team,

I am facing issue while using DATEADD function in MS Power BI report and getting inconsistant results i.e., Few rows are showing correct results and few rows are not showing(blanks))

Formuls - DATEADD(Merge_HR[Date Completed].[Date], Merge_HR[RiskTest], MONTHS)

Example: DATEADD('6/8/2022 12:00:00 AM', 12, MONTHS)

Thanks,

Vijay

Re: Facing issue while DATEADD(Merge_HR_TSR[Date Completed].[Date], Merge_HR_TSR[RiskTest], MONTHS)

v-chenwuz-msft — Wed, 22 Jun 2022 07:50:21 GMT

Hi Anonymous ,

The result depends on whether the desired date is in the date field or not, if it is, it is displayed, if not, it is blank.

For more details you can refer this link.

DATEADD function (DAX) - DAX | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.