Forum Discussion
Solved
Modelling Q&A - Help Needed
I have the following Fact Table (small sample): Fact table is a Sharepoint table. As you can see for Tool column there are cells (lists) which collects more than one tool, like row 2 or 4. A...
Create a relationship between the tables on the ID column
and set the Cross-filter direction to both
Regards
Phil
Hi,
In Power Query, split the Tool column of the Fact table into rows. based on the , separaor.