I want to draw a 1:M relationship between dimension and fact table.
The fact table contains a column that may have multiple values in a single cell separated by tab as shown in the picture:
The red line shows multiple values in a cell. I also got unique values of the column as a dimension table. Now I am not sure how should I draw 1:M relationship between dimension and fact table. Could anyone please help me in overcoming the issue?
sample.pbix (111.3 KB)