Forum Discussion
Solved
Filtering by individual values in a single cell
Hi I've found lots of references to comma seperated values but not quite what I'm after. I have a file with multiple fields, listing various details for different programs we run. The data comes f...
Hi bennyjmc
Split Column is probably the best option here as doing it with DAX would not be efficient.
You can avoid all the problems of Unpivoting, if you use Split into Rows option as on the screenshot below.Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
Community Champion
Community ChampionHi bennyjmc
Split Column is probably the best option here as doing it with DAX would not be efficient.
You can avoid all the problems of Unpivoting, if you use Split into Rows option as on the screenshot below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Can't believe that's all I was missing.. Thanks heaps!