Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day,
I am encountering an issue that I believe has something to do with my Locale settings. Nonetheless I have not yet figured out the reason why this is not working. I am doing a calculation that results in a decimal number (0,72).
The issue I am having is with this below formula, it is not returning the correct Text. It should be seen as "Strong" however it returns "Moderate"
Formula (The CC is the name of the variable that returns the 0.72 as mentioned before)
Please keep in mind that I have tried using full stops (0.30) but it gives an error in the Formula bar.
Solved! Go to Solution.
@Anonymous
You need to replace the "||" with "&&". "||" is an alternate for "Or".
In your formula , if the value is more than 0,30 or less than 0,50, that will give "Moderate" and 0,72 is more than 0,30.
I would suggest you change your formula as below
Option 1:
IF ( CC <= { 0, 30 }, "Weak", IF ( CC > { 0, 30 } && CC <= { 0, 50 }, "Moderate", IF ( CC > { 0, 50 } && CC <= { 0, 99 }, "Strong", IF ( CC = { 1 }, "Perfect", "No" ) ) ) )
SWITCH ( TRUE (), CC = 1, "Perfect", CC > 0,50, "Strong", CC > 0,30, "Moderate", CC <= 0,30, "Weak", "No" )Thanks
Hi RuanG,
You can use switch statement to check the condition of this statement.
Like,
@Anonymous
You need to replace the "||" with "&&". "||" is an alternate for "Or".
In your formula , if the value is more than 0,30 or less than 0,50, that will give "Moderate" and 0,72 is more than 0,30.
I would suggest you change your formula as below
Option 1:
IF ( CC <= { 0, 30 }, "Weak", IF ( CC > { 0, 30 } && CC <= { 0, 50 }, "Moderate", IF ( CC > { 0, 50 } && CC <= { 0, 99 }, "Strong", IF ( CC = { 1 }, "Perfect", "No" ) ) ) )
SWITCH ( TRUE (), CC = 1, "Perfect", CC > 0,50, "Strong", CC > 0,30, "Moderate", CC <= 0,30, "Weak", "No" )Thanks
Thanks Option 2 worked well, I just needed to incase the decimals values in {} brackets, thanks for your help !
Can you please share some sample data?
Unfortunately not - Its a large dataset in order to calculate the correlation coeficient
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |