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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Ait-james
Frequent Visitor

If or Switch statment based in percentage value

Hello,

 

I would like to to apply a condition based to percent value I have, how I can do that please ?

 

When I tried this formul I got an error msg.

 

Aitjames_0-1630264215536.png

 

1 ACCEPTED SOLUTION
FirasAlramli
Regular Visitor

replace 20% by 0.20

View solution in original post

3 REPLIES 3
FirasAlramli
Regular Visitor

replace 20% by 0.20

thank you, it's working well !

How to use Switch function for 20 to 40 Percentage and 40 to 100 percentage in same function.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Kudoed Authors