dax. calculate
1 Topic
Power BI Dynamic Grouping
I've a requirement on a Table to summarise the data based on below scenarios: The Table 1 is the existing, the Table 2 is what is expecting. Table 1 Item# ItemName Reason Catogery LostSales 28783 Item 1 Orders waiting cat1 $54 28783 Item 1 Short Term Out Of Stock cat1 $13 28844 Item 2 Long Term Out of Stock cat 2 $78 29193 Item 3 Orders waiting cat 3 $15 30151 Item 4 Discontinue cat 4 $302 30311 Item 5 Not applicable cat 5 $64 30663 Item 6 Orders waiting cat 6 $418 Table 2 Item# ItemName Reason Catogery LostSales 28783 Item 1 Mixed cat1 $68 28844 Item 2 Long Term Out of Stock cat 2 $78 29193 Item 3 Orders waiting cat 3 $15 30151 Item 4 Discontinue cat 4 $302 30311 Item 5 Not applicable cat 5 $64 30663 Item 6 Orders waiting cat 6 $418 Any one help on this achieving the Table 2.Solved2.2KViews0likes4Comments