Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[prabhat ranjan sharma]

Hi All,

I am trying to find a way to solve below problem :
Lets say I have a table as shown below 

Now i am trying to convert this table into below table ( Positive and negative in separate columns but same row )

Tried multiple conditional custom column but not yet solved .
Please let me know for any solution to this .

Regards,
Prabhat

——————————
prabhat ranjan sharma
powerbi consultant
——————————

[colin mcilwain]

Hi
You can use the conditional column to separate the positive and negative items then pivot this column to aggregate the rows. See below with some additional scenarios to handle summing multiple positive or negative values.

Result

?See attached pbix.

Regards,
?Colin.

——————————
colin mcilwain
Lead Process Specialist
——————————
——————————————-

[prabhat ranjan sharma]

Thanks Colin !!! 

It solution has worked for my dataset

——————————————-