DATE ADD: blank if result is over the end of the year

[matteocarnelos]

Hi,

I think there is a bug in the function DATEADD(<dates>,<number_of_intervals>,<interval>😞

when <dates> + <number_of_intervals> is grater than the end of the year, the result is blank.

[v-qiuyu-msft]

Hi @matteocarnelos,

This is how DATEADD function works, as per this online article, the result table includes only dates that exist in the dates column. For more information, see v-yuezhe-msft's reply here: https://community.powerbi.com/t5/Issues/Date-Table-cannot-calculate-a-date-outside-of-the-table-rang...

Best Regards,
Qiuyun Yu