Forum Discussion
How to Create a Custom Column by using IF Statement
Hi Guys,
I am new to PowerBI.I have been creating a report which need a Custom Coulumn "RPC"
So my formula is
=IF(SoldClicks > 0 , Revenue/SoldClicks,0)
Please see the attached image;
What i am doing wrong ?
Thanks
I'm guessing that you're using an if to prevent division by zero, just make it as a conditional column giving it the value 0 if it's 0 otherwise give it the value rev, then amend that in the formula bar to rev/soldclicks:
No, it doesn't, which is why I indicated to amend it in the formula bar afterwards. Just set it to be one of the two in the conditional column tool and change it once you've got that done.
4 Replies
I'm guessing that you're using an if to prevent division by zero, just make it as a conditional column giving it the value 0 if it's 0 otherwise give it the value rev, then amend that in the formula bar to rev/soldclicks:
Thanks for your Prompt Reply.
But in "Conditional Column", it does not allow me to divide two fields.Thanks
No, it doesn't, which is why I indicated to amend it in the formula bar afterwards. Just set it to be one of the two in the conditional column tool and change it once you've got that done.
