Forum Discussion
Calculation of conversion differences
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
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
2 Replies
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
It helped a lot - Thank you very much
