Forum Discussion
Solved
Convert the Value into Percentage based on condition
Dear All, I am infant topower bi and facing some challenges due to being new to power bi I am holding data in below format Company Q2 FY 2018 Q3 FY 2018 Q4 FY 2018 Q1 FY 2019 ...
Hi infantpowerbi ,
Can you use calculated column? If yes, you can try the formula below. If not, I think you need to convert the Value column to percentage entirely.
Z Percentage = IF('Table'[Company] = "Z",FORMAT('Table'[Value],"00.00%"))Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
My client denied to use measure,
So can we convert value column into percentage where company is equal to z
My client denied to use measure,
So can we convert value column into percentage where company is equal to z
Hi infantpowerbi ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.