Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ArthurKvalheim
Regular Visitor

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

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?

ArthurKvalheim_0-1662030806338.png

 

 



Same with Tilbuddato as this:

ArthurKvalheim_1-1662030571089.png

 

 

2 ACCEPTED SOLUTIONS

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

View solution in original post

ArthurKvalheim
Regular Visitor

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

ArthurKvalheim_0-1662036013323.png

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 🙂

View solution in original post

6 REPLIES 6
ArthurKvalheim
Regular Visitor

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

ArthurKvalheim_0-1662036013323.png

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
Regular Visitor

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:

ArthurKvalheim_0-1662035621087.png


All though I would like a text-result.

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

PowerUserR
Solution Supplier
Solution Supplier

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.

Appreciate your respons and suggestion. Thanks!

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

ArthurKvalheim_0-1662034290406.png

 



Hi again,

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors