Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Merge Question

Hi there ;   İ have two tables as below Table A and Table B , just i want to create lookup , and on table B i want  to see currency , but when i use merge sytem gives me 8 rows data as i attached "...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi erhan_79 ,

     

    make a copy of Table A and group it by keycode and currency.

    This should then be your lookup table.

     

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

erhan_79   Add a column to your table B like so.

Curr = LOOKUPVALUE ( 'Table A'[Currency], 'Table A'[Keycode], 'Table B'[Keycode] )
erhan_79's avatar
erhan_79
Post Prodigy
6 years ago

jdbuchanan71 

 

thank you but , i want to create new colum on query side , i think you gave me DAX formula