IF and SUMIFS like in Excel. I beg for help, I'm desperate

[Alexsay]

Hello everyone, Hello world

I searched for a long time for a solution but nothing for me and I hope from the bottom of my heart that maybe you can help me
So, I have a report from the VBRP SAP table with items from invoices and are some items without value because represent a component item from another
The idea is to replace the zero with the component value. In exlce I managed that but I need it in power querry
For below example the 2nd line has no net value but with formula I take the net value from line three and I use the reference HgLvIt

Cl.	Bill.Doc.	Net value	Item	HgLvIt	Subtotal 3	New NET VALUE
010	5872804964	9,031.68	10	0	9,031.68	9031.68
010	5872804964	0.00	20	0	0.00	11780.64
010	5872804964	11,780.64	30	20	11,780.64	11780.64
010	5872804964	16,730.56	40	0	16,730.56	16730.56
010	5872804964	14,126.40	50	0	14,126.40	14126.4

I need the same think in PowerQuerry.
Thanks a lot in advance!!!

 

[Wishmaster40]

I don't know how to do this in PQ, but why don't you create a ABAP report or a Query in SAP itself?

Do you just need data from the VBRP table or you are also using the VBRK and VBRP table?
Also keep in mind SAP has a lot of Sales reports like the KE30, in this transaction you can create your custom reports and change the data anyway you like.

I assume your item 20 is a service article or a BOM and that's why it doesn't have a value in the VRBP?

 

[RoryA]

Add a new column using:

=if [Net value] = 0 then Table.SelectRows(Source, (x)=> x[HgLvIt]=_[Item]){0}[Net value] else [Net value]

This assumes Source is the previous step name, so amend as needed.