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
Syndicate_Admin
Administrator
Administrator

Error formulates "DAX comparison operations do not support comparison values of type TEXT"

Hello Community,

I have a problem with a formula, please your support

Classification =
IF(and(RECCS_Terreno[NotaFinal]=0,RECCS_Terreno[NotaTerreno]=0),"No presence",
IF(AND(RECCS_Terreno[NotaFinal]=0,RECCS_Terreno[NotaTerreno]<>0),"Incomplete",
IF(RECCS_Terreno[Contractor Category]="A"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",
IF(RECCS_Terreno[Contractor Category]="A"&&RECCS_Terreno[NotaFinal]>=80,"Moderate",
IF(RECCS_Terreno[Contractor Category]="B"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",
IF(RECCS_Terreno[Contractor Category]="B"&&RECCS_Terreno[NotaFinal]>=70,"Moderate",
IF(RECCS_Terreno[Contractor Category]="C"&&RECCS_Terreno[NotaFinal]>=80,"Acceptable",
IF(RECCS_Terreno[Contractor Category]="C"&&RECCS_Terreno[NotaFinal]>=60,"Moderate",
IF(RECCS_Terreno[Contractor Category]="D"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",'Unacceptable')))))))))}
JosVP_0-1680124299510.png

Thank you!

1 REPLY 1
CharbelArmaleh
Resolver II
Resolver II

Hello,

 

You need to check the data type of the following column

RECCS_Terreno[NotaFinal]

RECCS_Terreno[NotaTerreno]

RECCS_Terreno[NotaFinal]

they should be a whole number of decimal


Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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