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.
Hi Everyone . I need help regarding calculation .How to calculate total quantity per category per week ?Appreciate your help. Below is the chart for your reference.
Solved! Go to Solution.
1) You need a date table with two columns: Date and Weeknumber.
2) Connect two Date Columns from two tables.
3) Then plot a Matrix visual, put Weeknumber to Columns, Category to Rows, Total quantity to Values.
1) You need a date table with two columns: Date and Weeknumber.
2) Connect two Date Columns from two tables.
3) Then plot a Matrix visual, put Weeknumber to Columns, Category to Rows, Total quantity to Values.
Thank you .Got it.
Lets say A category has total quantity of 2 in week 13 , 3 in week 12 and so on .
How does your raw data look like?
Yes this the expected result .Need to calculate total quantity per week
Is it the expected result? How does your raw data look like?
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |