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

[VijayakumarP]

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

[v-chenwuz-msft]

Hi @VijayakumarP ,

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.