Calculation of conversion differences

[shafti]

Hi, 

I've built my consolidation in Power Query and now I need one last piece of the puzzle in place to work out the conversion difference. I have used SUMIFS in Excel to calculate the amount between average and closing FX rate based on the transaction list and placed the calculation in the separate line on account no. 2085.

SUMIFS([Amount calculated between average and closing rate] ;[Scenario]&[Period]&[Entity];[Account 2085])

How do I handle similar formula (SUMIFS, Index or vlookup) in Power Query?

Would be very grateful to receive an answer to this challenge?

Kind regards

Shawn

[adudani · Accepted solution]

hi @shafti ,

maybe this will help.

(7) SUMIF in Power Query - YouTube

if you could provide sample input data in a table/ json removing sensitive information it would be easier to test against.

thanks

[shafti]

It helped a lot - Thank you very much