Replace value with Satisfying condition

Question

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 &amp; output.&nbsp;Condition: Replace the distributor with Sales is less and Shipments is more&nbsp;&nbsp;&nbsp;

daniel29195 · Answer

PrakashPalle&nbsp;sorry didnt understand the requirement .&nbsp;

prakashpalle · Answer

Hi&nbsp;Daniel29195&nbsp;,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 · Answer

PrakashPalle&nbsp;sorry for the late reply .i still dont understand , what do you mean&nbsp; by : replace&nbsp;the distributor with Sales is less and Shipments is more.&nbsp;sales is less than what&nbsp; ?&nbsp; shipments is more than what ?&nbsp;&nbsp;&nbsp;

prakashpalle · Answer

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

Forum Discussion

Replace value with Satisfying condition

4 Replies

Related content

Conditional Replace Using Outside table

Replace value based on condition from other column

Table Replace Value multiple condition

Replace value in Power Query based on condition

Replace NULL