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.
Hello CNENFRNL thank you for your help. In reality it is a star schema model. I just wanted to simplify it here 🙂 Nonetheless your solution just might work for my purposes (I will try it tomorrow) and it definetly works for the challenge I wrote about here as your pbix clearly demonstrates, so I'll accept it as the solution! Thank you once again!
A solution a bit more robust if there were, by mistake, duplicates in PRODUCT table.
Product_IDDimensions
| 1 | Width=2 |
| 1 | Height=1 |
| 1 | Length=1 |
| 2 | Width=2 |
| 2 | Height=1 |
| 2 | Length=2 |
| 2 | HEIGHT=1 |