Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Below is my source Data:
Store number | Style | Group | TY Unit | LY Unit | TY INVENTORY | LY INVENTORY |
1 | apple | F | 5 | 5 | 8 | 17 |
1 | watermelon | F | 7 | 8 | 7 | 14 |
1 | blueberry | F | 8 | 7 | 6 | 12 |
1 | pear | F | 10 | 4 | 2 | 16 |
2 | apple | F | 3 | 6 | 3 | 25 |
2 | watermelon | F | 7 | 9 | 23 | 14 |
2 | blueberry | F | 6 | 3 | 82 | 9 |
2 | pear | F | 5 | 2 | 32 | 8 |
3 | apple | NF | 4 | 8 | 20 | 13 |
3 | watermelon | NF | 1 | 5 | 23 | 11 |
3 | blueberry | NF | 7 | 1 | 32 | 10 |
3 | pear | NF | 8 | 2 | 33 | 8 |
4 | apple | NF | 2 | 5 | 25 | 9 |
4 | watermelon | NF | 6 | 5 | 78 | 8 |
4 | blueberry | NF | 6 | 6 | 54 | 15 |
4 | pear | NF | 6 | 4 | 32 | 4 |
"TY INV VS LY" and "TY UNIT VS LY" are new measures added that calculate the change. However I can only create a Matrix below by dragging "Group" to the Columns section and "TY INV VS LY" and "TY UNIT VS LY" to the Values section.
I would like to use "TY INV VS LY" and "TY UNIT VS LY" as the group and "F" & "NF" as values names.
Essentially stwitching "Columns" names and "Values" names and group "TY INV VS LY" columns together and "TY UNIT VS LY" columns together.
My ideal table is like this :
Is there a way to achiech this in BI?
Any comments or suggestions would be appreciated!
@gwjjjjj , if you need to measure the above dimension, you need to create a calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |