IF-formula: Comparing if one date is greater than another date returns #Error

[ArthurKvalheim]

I am trying to make a new coloumn which should state if a certain date-field is later than another date-field, but I receive the value #ERROR, and an error-message saying the DAX comparison cannot compare values of True/False with values of Text - but I have set both fields/coloumns to Date.

Any one know how to solve?

Same with Tilbuddato as this:

[Anonymous · Accepted solution]

Okay, well you could always try using another IF-function outside of the current one to try to manipulate the answers back to text. 

[ArthurKvalheim · Accepted solution]

Finally, testing different things with good help from PowerUserR, this worked:

It seems the DAX-formula in Power BI won't let you return a text-result on this date-comparison - but with this somewhat strange workaround it will 🙂

[ArthurKvalheim]

I have now tried inserting DATEVALUE, VALUE, FORMAT and other similar to the date-fields in the logic-part of the DAX-formula with no success - but:

When I changed the result-part of the formula from "Ja" and "Nei", to 0 and 1, this seemed to solve the error.

This works:

All though I would like a text-result.

[Anonymous · Accepted solution]

Okay, well you could always try using another IF-function outside of the current one to try to manipulate the answers back to text. 

[Anonymous]

Hi,

I don't see any errors in the calcualtion but I was thinking that the date format of using "."  could maybe trouble dax? Try to replace with "/" and see if that works.

[ArthurKvalheim]

Appreciate your respons and suggestion. Thanks!

I have now tried different date-formats, but with no success. Still the same error-message.

[Anonymous]

Hi again,

Could you try using DATEDIFF?
Try setting the condition to see if it's a positive or negative