IF statement for identifying data type.

The 'IF' statement has two possible outcomes.  They must both be of the same data type.

Hey,

this is due to the fact, IF can not return values of different data types, your statement will return a date (Ordered Date) or a string "".

You can use this instead:

Column = IF('Table1'[CheckCondition] = "Calendar" , 'Table1'[Ordered Date] , BLANK())

Instead of returning an empty string "", return BLANK(), if the IF condition equals to FALSE

Hopefully this is what you are looking for.

Regards,

Tom