DAX not applying for all cells in the calculated column

[ruban]

Hi,

I wrote an if statement based  DAX to create a new column but it is not working for all the cells in the calculated column. 

I create the Lost Date column in the image below based on an if condition on the adjacent column. I f you see the last row in the image should also have a value but it is blank.  could someone help me to solve this issue?

Thanks in advance

 

Ruban

[HotChilli]

DATEADD is a bit sneaky ....."The result table includes only dates that exist in the dates column."

I think you have to build a date with your own formula OR build a date table with a wider range

[ruban]

Thanks the info. I changed the dax by replacing Dateadd() with Date ()

[v-lili6-msft · Accepted solution]

hi, @ruban 

Use Date () Function needs to consider the leap year condition, that may be a bit complex.

You could try this simple way:

use CALENDAR() to create a wider range date table

for example:

Date = CALENDAR(MIN(Table1[procdate])-549,MAX(Table1[procdate])+549)

Then create the relationship between date table with lost_patients table by date column and procdate column

Then continue to use your formula

Result:

Best Regards,

Lin

[ruban]

thanks Lin