• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting IF statement to Power BI


New Member
I'm trying to covert the following Excel IF statement to a custom column in Power BI: =IF(O2<>P2,IF(O2>0,O2,P2),IF(P2=0, N/A,P2)) (replacing the cells with the column names)
I cannot for the life of me figure out the syntax.

Any assistance is GREATLY appreciated.


Excel Ninja
Where in PowerBI?

Is it in DAX or "M" query?

If in DAX is it calculated column or measure?

I'd recommend uploading sample raw data and expected output.