Replace null Value, to Date Value

[gabrielvigo]

I need repleace some values in my table.

I have a last check in , a last check out and some users that not have a check out (null)

Some have a last check out before check in, this is because the person is inside.

I need to modify the check out time when these situations:

• The last check out are before the last check in.
• The check out is null.

I use this formula:

#"Columna condicional agregada" = Table.AddColumn(#"Filas filtradas", "FechaSalida", each if [Salida] = null then [Ingreso] else if [Salida] < [Ingreso] then [Ingreso] else if [Salida] > [Ingreso] then [Salida] else null),

I need that in this case [Salida] = null the data will "Today()+1".

But if I replace then [Ingreso] with "Today +1" have ERROR.

Can you help me?

[v-cherch-msft · Accepted solution]

Hi @gabrielvigo

You may try to convert the type of date value to text.For example: Using FORMAT Function in dax.

FORMAT(TODAY()+1,"MM/DD/YYYY")

Regards,

Cherie