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 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
Solved! Go to Solution.
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.
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.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |