Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have created below DAX to convert the values from another table using Lookup and concatination in front end. it is working as expected.
Can you please help me to write the same logic in PowerBI M-Query(Power Query Editor). as I have to use this new column in power query editor to append the tables.
=#"FX Rate"{[#"year-month-currency"=Text.Format("#[Year]#[Month]#[Invoice currency]",_)]}?[Conversion factor]?
Hi Daniel- Thanks for your responce.
I have tried with above query and it ran successfully but values are showing null.
= Table.AddColumn(#"Removed Other Columns", "F_X", each #"FX Rate"{[#"year-month-currency"=Text.Format("#[Year1]#[Month1]#[Invoice currency]",_)]}?[Conversion factor]?)
Even I have created required fields from FX Rate table.
please show us the headers of both tables