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
plaliberte
Frequent Visitor

DAX comparison operations do not support comparing values of type True/False with values of type Int

HI,  

 

I am not sure where my error is in the below switch statement.   I keep getting the error on the subject line.  Any and all help is appreciated.

 

Column = SWITCH (TRUE(),
AND ([# of Staffed Beds] >0,[# of Staffed Beds] <=24), "Less than 25",
AND ([# of Staffed Beds] >=25,[# of Staffed Beds]<=49),"25-49",
AND([# of Staffed Beds] >= 50, [# of Staffed Beds]) <= 99, "50-99",
AND ([# of Staffed Beds] >= 100, [# of Staffed Beds] <= 249), "100-249",
AND ([# of Staffed Beds] >= 250, [# of Staffed Beds]<= 499), "250-499",
AND ([# of Staffed Beds] >= 500,[# of Staffed Beds]<= 999), "500-999",
AND ([# of Staffed Beds] >=1000, [# of Staffed Beds]<= 9999999999999999999), "1,000+", BLANK(),
"Unknown")
0 REPLIES 0

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.

Top Solution Authors