Forum Discussion
Relating a multiple entry column with single entry column
Download PBIX file with the example shown below
You need to split the Codes column in the first table into separate rows for each code. Do this by splitting the column by delimiter (space) in Power Query, choosing to create rows rather than the default columns
You can then have a 1 to many relationship between table2 and table1 on the Code field, this will allow you to associate the codes in Table1 with the descriptions in Table2 - but that isn't required if you just want to count entries from table1?
If this isn't what you are after, please show an example of the desired result.
Regards
Phil
Download PBIX file with the example shown below
You need to split the Codes column in the first table into separate rows for each code. Do this by splitting the column by delimiter (space) in Power Query, choosing to create rows rather than the default columns
You can then have a 1 to many relationship between table2 and table1 on the Code field, this will allow you to associate the codes in Table1 with the descriptions in Table2 - but that isn't required if you just want to count entries from table1?
If this isn't what you are after, please show an example of the desired result.
Regards
Phil
Wow! Thank you.