Forum Discussion
Retrieve Multiple Columns From Another Table
Hi Anonymous ,
You could use lookupvalue function to realize it.
Syntax:
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] )Check here for more details.
Also check below blog for reference:
https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Anonymous , In this case, better option is to merge in power query
Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Or you need two create new columns for all those required columns.
If DAX we prefer dimensions to remain separate. So unless it is most required, you should avoid it.
Hello thanks a lot for your reply. However as the number of rows differ merge operation is not working. Only option seems to retrieve each column one by one for now.