Forum Discussion

Elios's avatar
Elios
Regular Visitor
5 years ago
Solved

Compare text and integers

Hello,   I am a beginner in Power BI.   I have the following problem, I have an excel code that works just fine in excel but when I translated it to DAX the following error message appears : "DAX...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    5 years ago

    Hi Elios ,

    Have you tried wrapping your  formula with ISERROR? This should return TRUE/FALSE and then in the data view you can filter this to just TRUE and inspect the data. Otherwise you might have to clean your data first in Power Query - removing special characters and text from the field.

    I agree with PhilipTreacy , a sample data would be very useful. We understand its confidentiality so a dummy sample data would do - remove confidential information or obfuscate it one way or another.

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Elios 

Please supply sample data and explain what comparsons you are trying to make and it'll probably be easier to help you.

regards

Phil

Elios's avatar
Elios
Regular Visitor
5 years ago

Unfortunatly i cannot supply you with a sample data.

 

However the comparisons are colums containing text, some columns containing numbers. Since some of the checks contain >0 conditions, i cannot turn them into text.

 

Is there a way to see where the conflict happens from the Power BI interface ?