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.