Calculation based on condition in Power-BI

Abhishek Govilkar 21 Reputation points

I have a data table that I would like to make a new column based on the calculation with certain conditions.

A sample of my dataset is as below:


I would like to create a new column "Retailer Margin" with a formula as below:

Retailer Margin = [MRP] - [Retailer Landed Price]

As my data for retailer landed price also have some null (0) values and I want the condition that in such cases calculation should not happen and it should give a "Null" value.

The expected information for new column should be like following:


Any help on the same will be highly appreciated.

Thanks in advance!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,405 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Leon Laude 85,676 Reputation points

    Hi @Abhishek Govilkar ,

    Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here

    You may ask the experts in the dedicated Power BI forum over here:


    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,

    0 comments No comments