DATEADD ( Leap Year Error )

prafullchavan1 · June 26, 2021, 4:38am

I am using “Dateadd” function to evaluate last year value. But it is showing null for Feb’21.

Also showing null values for some months.

Thanks in advance

Anurag · June 26, 2021, 5:17am

Hi,

Power bi with date add function goes exactly 12 month back and search for 28 feb 20 for 28 feb 21 and i do not see any record in your data for that date that why its coming empty .

I hope this explanation help you .

you can see when i look into month wise you can see data for feb 2021

prafullchavan1 · June 28, 2021, 1:26am

Thanks for your help

EnterpriseDNA · June 28, 2021, 4:17am

Hi @prafullchavan1 , did the response provided by @Anurag help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!