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.
I have a table with a column that shows percentages as shown in the below image (column C), now I want to create a column on based on the percentage values in column C. For example, if the percentage is greater than or equal to 10 then output should "Incorrect Data" else if the percentage is less than 10 then output should be "correct data". How to achieve this condition column in Power BI on based on percentage values column?
Thanks!
Solved! Go to Solution.
The percentage(%) column is created measure.
Hi @ta5656
You may create a measure as below:
Measure 3 = IF([Percent]>=0.1,"Incorrect Data","Correct data")
Regards,
Cherie
@Anonymous Thanks for the response.
Can you guide me on how to relate values as decimals?
Thanks!
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |