topic Re: Problem with variant data type in calculated column in DAX Commands and Tips

Problem with variant data type in calculated column

Anonymous — Thu, 24 Mar 2022 09:58:50 GMT

I am trying to use an if statement that uses a "fake" date when an order haven't been assigned a arrival date.

But when writing this seemingly easy piece of code I get the below error message saying that it "can't return a variant data typ..."

There has to be a way around this. Does anyone know?

Thanks in advance!

Re: Problem with variant data type in calculated column

Anonymous — Thu, 24 Mar 2022 10:14:11 GMT

Hi Anonymous
try using DATE(2999,12,31) in the second argument of IF() statement in place of "2999-12-31"

Re: Problem with variant data type in calculated column

daXtreme — Thu, 24 Mar 2022 10:46:29 GMT

"2999-12-31" is a string, not a real date. Use the DATE function.

Re: Problem with variant data type in calculated column

Anonymous — Thu, 24 Mar 2022 11:11:55 GMT

Thanks for both answers!

However I've tried that before and yes, the code works. But then I instead face the problem that Arival-date has the wrong data type. The end result is a column where I can change the type to Date (so that I can use a Date interval as a slicer).