Forum Discussion
ells69
Helper I
Helper Ialternative to merge to retrieve description fields
In M I have a fact query with many keys in. Lets Call it "Fact". I have several querys that have the matching description LKUP_Product which consists of [ProductID], [ProductName],[Product Colur] ...
If you're going to be loading these tables to a data model, you can just use a one to many relationship and link them that way. Otherwise I would add a custom column using each Table.FindText.
--Nate