Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can anyone can help how to calculate the each items average quantity per day per store.
I have 10 different items which is sold in the month of april and may .
Usually i calculate Total quantity /working days of the respective month.
Kindly let me know how to put it in powerbi.
Hi @vidya_ar,
Please provide us some sample data, and elaborate your expected result, so that we can make further analysis.
Regards,
Charlie Liao
Please find the Sample sheet.
STORE NAME,ITEM NAME,QTY,MONTH,Working Days,per day per store
STORE1,shirt,100,Jan-17,31,3.2
STORE1,salwar,500,Jan-17,31,16.1
STORE1,salwar-m,1234,Jan-17,31,39.8
STORE1,salwar-l,567,Jan-17,31,18.3
STORE1,salwar x,234,Jan-17,31,7.5
STORE1,towel,111,Jan-17,31,3.6
STORE2,vegitable,12,Jan-17,18,0.7
STORE2,shirt,200,Jan-17,18,11.1
STORE2,salwar,467,Jan-17,18,25.9
STORE2,salwar-m,233,Jan-17,18,12.9
STORE2,salwar-l,111,Jan-17,18,6.2
STORE2,salwar x,121,Jan-17,18,6.7
STORE2,towel,567,Jan-17,18,31.5
STORE2,vegitable,22,Jan-17,18,1.2
STORE1,shirt,56,Feb-17,28,2.0
STORE1,salwar,11,Feb-17,28,0.4
STORE1,salwar-m,2,Feb-17,28,0.1
STORE1,salwar-l,567,Feb-17,28,20.3
STORE1,salwar x,344,Feb-17,28,12.3
STORE1,towel,66,Feb-17,28,2.4
STORE2,vegitable,12,Feb-17,10,1.2
STORE2,shirt,2,Feb-17,10,0.2
STORE2,salwar,54,Feb-17,10,5.4
STORE2,salwar-m,88,Feb-17,10,8.8
STORE2,salwar-l,222,Feb-17,10,22.2
STORE2,salwar x,888,Feb-17,10,88.8
STORE2,towel,11,Feb-17,10,1.1
STORE2,vegitable,11,Feb-17,10,1.1
Hi @vidya_ar,
Store Name | Item Name | QTY | Month | Working Days | Per day per store |
STORE1 | shirt | 100 | 17-Jan | 31 | 3.2 |
STORE1 | salwar | 500 | 17-Jan | 31 | 16.1 |
STORE1 | salwar-m | 1234 | 17-Jan | 31 | 39.8 |
STORE1 | salwar-l | 567 | 17-Jan | 31 | 18.3 |
STORE1 | salwar x | 234 | 17-Jan | 31 | 7.5 |
STORE1 | towel | 111 | 17-Jan | 31 | 3.6 |
STORE2 | vegitable | 12 | 17-Jan | 18 | 0.7 |
STORE2 | shirt | 200 | 17-Jan | 18 | 11.1 |
STORE2 | salwar | 467 | 17-Jan | 18 | 25.9 |
STORE2 | salwar-m | 233 | 17-Jan | 18 | 12.9 |
STORE2 | salwar-l | 111 | 17-Jan | 18 | 6.2 |
STORE2 | salwar x | 121 | 17-Jan | 18 | 6.7 |
STORE2 | towel | 567 | 17-Jan | 18 | 31.5 |
STORE2 | vegitable | 22 | 17-Jan | 18 | 1.2 |
STORE1 | shirt | 56 | 17-Feb | 28 | 2 |
STORE1 | salwar | 11 | 17-Feb | 28 | 0.4 |
STORE1 | salwar-m | 2 | 17-Feb | 28 | 0.1 |
STORE1 | salwar-l | 567 | 17-Feb | 28 | 20.3 |
STORE1 | salwar x | 344 | 17-Feb | 28 | 12.3 |
STORE1 | towel | 66 | 17-Feb | 28 | 2.4 |
STORE2 | vegitable | 12 | 17-Feb | 10 | 1.2 |
STORE2 | shirt | 2 | 17-Feb | 10 | 0.2 |
STORE2 | salwar | 54 | 17-Feb | 10 | 5.4 |
STORE2 | salwar-m | 88 | 17-Feb | 10 | 8.8 |
STORE2 | salwar-l | 222 | 17-Feb | 10 | 22.2 |
STORE2 | salwar x | 888 | 17-Feb | 10 | 88.8 |
STORE2 | towel | 11 | 17-Feb | 10 | 1.1 |
STORE2 | vegitable | 11 | 17-Feb | 10 | 1.1 |
For your sample data, the working days for STORE1 in Janauary in 31, and for STORE2 is 18, how do you get the value?
Regards,
Charlie Liao
Hi
Store1 Workign Days:
Jan month -31 days
Feb month-18 days
Store 2 Workng Days:
Jan month -28 days
Feb month -10 days
Working days should be common for all the items for their respective month.
Final Result sample should be as belwo:
Total Salwar per day for Jan and Feb month
Total Shirt per day for Jan and Feb month
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |