Forum Discussion
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...
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
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
