Forum Discussion
Conditional column: compare column table1 against table2, if match return value of a column table2
Hello, I don't know M.Query, however I hack and try find solutions on my own. Desired Outcome Similar to VLOOKUP in Excel: Table 1 (fact table) = F-Cargo Table 2 (dimenstion table) = D-Airilne...
Hi adudani,
Thank you for your reply.
I tried your solution and it did not work for me.
Now that my head is clear I was able to find a solution through DAX.
I stepped out of query and I used LOOKUPVALUE in the DAX environment.
See also 4 Ways of Getting Column from one table to another in Power BI https://www.youtube.com/watch?v=b1QtgQfwN04
Big thanks for giving me your time.
Have a great day!
DAXRichard