Percentage split to existing rows.

[_Kevin_]

Hi please assist.

I have a table as follows:

Product	Amount
A	110
B	120
C	115
A/B	100
Tot	445

Some values need to be split by percentage, so I have the following table:

Product	A	B
A/B	40%	60%

I would like the result to show the split value added to their appropriate products and removed from the existing rows. The result would be:

Product	Amount
A	150
B	180
C	115
Tot	445

I'd prefer Dax, but will revert to Query editor if that is the suggested option.

Thanks

Kevin

[camargos88]

Hi @_Kevin_ ,

Check this file: Download PBIX 

[_Kevin_]

Hi @camargos88 

Excellent answer, thanks for the help.

My corporate security wouldn't let me access the file so took a while to get it.

regards

Kevin