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...
Need Help
Tips and Tricks
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.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      2 years ago

      please show us the headers of both tables