Forum Discussion
Solved
Remove null in a Calculated Date column
Hello everyone I have a newly set up list or table with little data so far. Inside it, there is a calculated date column that sadly displays 0 although no dates were given. Looks like this in Q...
Hi teflonreis
>> only if both dates are given, it calculates the difference. Else does not calculate anything.
Please add if judgment before your calculation statement,
IF('Table'[OrderDate]<>BLANK() && 'Table'[DeliveryDate]<>BLANK(), your expression)e.g.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
v-xiaotang
Community Support
Community SupportHi teflonreis
>> only if both dates are given, it calculates the difference. Else does not calculate anything.
Please add if judgment before your calculation statement,
IF('Table'[OrderDate]<>BLANK() && 'Table'[DeliveryDate]<>BLANK(), your expression)
e.g.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.