Combining max and if

Hey I have solution in Power Query,

Step 1: Merge the column todoid and budgetpostid, named as g_b

Step 2: Group by the column g_b

Step 3: Expand the rest table

Step 4: Add Custom Column

amount_temp = if [id_temp] = [id] then [amount] else 0

Step 5: Add Custom Column

E. udgifter = [amount_temp]/100

remove unnecessary columns and that's it.

I hope It will work for you.