https://community.fabric.microsoft.com/t5/Desktop/Help-with-currency-conversion-using-LOOKUPVALUE-with-Exchange/m-p/569365
Solved: Re: Help with currency conversion using LOOKUPVALU... - Microsoft Fabric Community
Nov 26, 2018 - Hi there, I would recommend doing the currency conversion in the Query Editor or source. Whilst the lookup does work if your dataset is large or
help withcurrency conversionmicrosoft fabricsolved