Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
101 | |
91 | |
83 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |