Forum Discussion

PrakashPalle's avatar
PrakashPalle
Icon for Helper II rankHelper II
2 years ago

Replace value with Satisfying condition

Hi Power BI Experts, I have a below requirement where i need to replace distributor name with the satisfying condition as sales is less and shipments is more. Below is the input & output.   Condit...
Need Help
  • PrakashPalle's avatar
    PrakashPalle
    Icon for Helper II rankHelper II
    2 years ago

    Hi Daniel29195 ,

    Thanks for your reply. Its very simple just want to replace the null value with the satisfying condition: "Sales is less and Shipments is more". Please check the output screen shot.

    • Daniel29195's avatar
      Daniel29195
      Icon for Community Champion rankCommunity Champion
      2 years ago

      PrakashPalle 

      sorry for the late reply .

      i still dont understand , what do you mean  by : replace the distributor with Sales is less and Shipments is more.

       

      sales is less than what  ?  shipments is more than what ? 

       

       

      • PrakashPalle's avatar
        PrakashPalle
        Icon for Helper II rankHelper II
        2 years ago

        Hi Daniel29195 , Thanks for your reply. Yes the sales & shipments are less than each distributor category.