Forum Discussion

VHosamane's avatar
VHosamane
Frequent Visitor
7 years ago
Solved

Match multiple columns and find corresponding values using DAX

Here is the scenario that I have and need help with DAX calculated field syntax to arrive with the two fields in the Transaction-Table.   I have a lookup table as shown, which has distinct rows wit...
  • HotChilli's avatar
    HotChilli
    7 years ago

    Use Power Query, Merge the queries on ClientName and ProjectName using a LEFT join (with the transaction table first).

    Expand the 'Table' column to return Product and Project Type.

    Replace any null value with N/A

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Remove the comma from before the parenthesis that ends CALCULATE.

 

Best

Darek

VHosamane's avatar
VHosamane
Frequent Visitor
7 years ago

Thank you Anonymous & HotChilli . I tried both solutions and went with solution mentiond by HotChilli. As Anonymous  rightly mentioned in the note that the solution would work only if there is no relationship. So it's very important to go through the details. Thank you very much to both of you.