Forum Discussion
Dynamic AND list
Hello, I have the following table: Product_ID Dimensions 1 Width=2 1 Height=1 1 Length=1 2 Width=2 2 Height=1 2 Length=2 I now want to return all Product_ID...
Simple enough in spite that I personally dislike such non-star-schema model.
Anonymous , In power query
1. Split Dimensions column by delimiter (=) , into new column
2. Then pivot the two columns, you should get new columns like Height and width
then you can use them as filter, if this can work
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hello amitchandak and thank you for your suggestion. The problem is that I have more than one hundred of different properties in the column I called Dimension for each Product_ID. Is there any way to make it work in the current form?