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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gelain
Frequent Visitor

ERROR BETWEEN INTEGER AND TEXT

 

Hello!

 

I created a calculated table, but the following error occurred in the formula:

 

FORMULA = FILTER (PBICAIXACNPJ; PBICAIXACNPJ[CODE] = "3")

 

DAX comparison operations do not support the comparison of Integer-type values ​​with values ​​of type Text. Consider using the VALUE or FORMAT function to convert one of the values. I changed the data type, but it did not work.

 

Please help me.

1 ACCEPTED SOLUTION
JoHo_BI
Responsive Resident
Responsive Resident

Try not using quote marks for the 3, just leave it as is. 

 

Quote marks should only be for text values, otherwise it'll auto chang ethe datatype to text. 

View solution in original post

2 REPLIES 2
JoHo_BI
Responsive Resident
Responsive Resident

Try not using quote marks for the 3, just leave it as is. 

 

Quote marks should only be for text values, otherwise it'll auto chang ethe datatype to text. 

@JoHo_BI,

 

Thanks for helping me. I did not realize this detail!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.