Look up values and write in same table

[Andreas_029]

Hi All

I''m new to Power Bi.

I'm working on a table that I got from our ERP database. Each row in that table is taken from our invoices and is either a sales item or a discount (on all items in the invoice and which is usually the last item on our invoices).

What I'm trying to achieve is to distribute that overall discount on all sales items. Each of them has a invoice number, a type (L for sales item, R for discount) and position number. Is there any way to look up the row with the discount, find all sales item of the same invoice number and write the discount in the respective discount field.

Below a simplified verson of my table:

Andreas

[Greg_Deckler]

What is the expected result?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490