I want create a new column in Power Query editor using the below dax

[gaddamkrishna]

I have created below DAX to convert the values from another table using Lookup and concatination in front end. it is working as expected. 

N_FX Rate = LOOKUPVALUE (

    'FX Rate'[Conversion factor],

    'FX Rate'[year-month-currency],

    CONCATENATE (

        CONCATENATE (

            '1 external workforce'[Year],

            '1 external workforce'[Month]

            ),

            '1 external workforce'[Invoice currency]

            )

            )

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.

[wdx223_Daniel]

=#"FX Rate"{[#"year-month-currency"=Text.Format("#[Year]#[Month]#[Invoice currency]",_)]}?[Conversion factor]?

[gaddamkrishna]

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.

[wdx223_Daniel]

please show us the headers of both tables