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.
Hi,
I have 2 column divided to get percentage but I am seeing only 0.0 even after changing the data type to whole number, percentage
if [Pending]= 0 then 0 else [overdue]/[pending]
Pending | Overdue | Percentage |
18 | 0 | 0.00 |
17 | 607 | 35.71 |
245 | 4 | 0.02 |
33 | 10 | 0.30 |
12 | 0 | 0.00 |
23 | 3 | 0.13 |
2 | 1 | 0.50 |
62 | 0 | 0.00 |
55 | 0 | 0.00 |
236 | 1 | 0.00 |
4 | 1 | 0.25 |
4 | 1 | 0.25 |
132 | 2 | 0.02 |
Solved! Go to Solution.
Hi @Sriku,
Did these replay help with your requirement? if this is a case, you can consider accepting the suitable one as a solution to help other users to find out the suggestion that faced a similar issue.
If not, you can feel free to post here with detailed descriptions.
Regards,
Xiaoxin Sheng
Hi @Sriku,
Did these replay help with your requirement? if this is a case, you can consider accepting the suitable one as a solution to help other users to find out the suggestion that faced a similar issue.
If not, you can feel free to post here with detailed descriptions.
Regards,
Xiaoxin Sheng
If you change the data type to "Whole Number", your decimal places will be ommited (so that you get zero's).
Change the data type to "Decimal Number" and Format to "Percentage".
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |