Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, thanks alot for reading my post!
As the subject describes I want to decompose some transactional data; my tables are
1) Transactional Data
What I want is to be able to see how many real SKU's I'm selling.
2) The BundlesTables; which tell's me what SKU are in the bundles and how the quantity
3) Result Table, Via DAX or the query editor I want to be able to get this table
Any Help will be much appreciated!
Solved! Go to Solution.
You may add a calculated table first.
Table = GENERATEALL ( 'Transaction', SELECTCOLUMNS ( FILTER ( Bundle, Bundle[Bundle] = 'Transaction'[Product] ), "P2", Bundle[Product], "Q2", Bundle[Quantity] ) )
You may add a calculated table first.
Table = GENERATEALL ( 'Transaction', SELECTCOLUMNS ( FILTER ( Bundle, Bundle[Bundle] = 'Transaction'[Product] ), "P2", Bundle[Product], "Q2", Bundle[Quantity] ) )