Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Ait-james
Frequent Visitor

If or Switch statment based in percentage value

‎08-29-2021 12:12 PM

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

 

Labels:
Message 1 of 4
2,849 Views
0
1 ACCEPTED SOLUTION
FirasAlramli
Regular Visitor

‎08-29-2021 12:32 PM

replace 20% by 0.20

View solution in original post

Message 2 of 4
2,810 Views
3 REPLIES 3
FirasAlramli
Regular Visitor

‎08-29-2021 12:32 PM

replace 20% by 0.20

Message 2 of 4
2,811 Views
Ait-james
Frequent Visitor
In response to FirasAlramli

‎08-29-2021 12:36 PM

thank you, it's working well !

Message 3 of 4
2,798 Views
0
Venkata17
New Member
In response to Ait-james

‎03-05-2023 05:56 PM

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

Message 4 of 4
1,874 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

View All
Top Solution Authors
View All