Forum Discussion

gaddamkrishna's avatar
gaddamkrishna
New Member
2 years ago

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

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.

Need Help
Tips and Tricks

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

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

    • gaddamkrishna's avatar
      gaddamkrishna
      New Member
      2 years ago

      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.