Forum Discussion

mudassar's avatar
mudassar
New Member
8 years ago
Solved

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; W...
  • jthomson's avatar
    8 years ago

    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:

     

  • jthomson's avatar
    jthomson
    8 years ago

    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.