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.
Hello people, I have this problem. I have a table with the following:
Can anyone please help me with the DAX formula on how many staffs do I need to add in my organization next month or next year if I add more sales or items being bought by my customers from my store?
Many thanks and more power to all of you guys.
Paging @Nathaniel_C.
Can you help me out with this roblem of mine. Thank you
Hi @daciga ,
We need more information, please.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel
Proud to be a Super User!
Hello @Nathaniel_C ,
Good evening from the Philippines. Here is the sample data in excel format. Apologies for the late reply.
Dennis
Date | Staff | Sales | Item Sold | Quantity (in kilos) |
2018-06-26 | Judy | 73,335.00 | Beans | 10 |
2018-10-05 | Sophia | 15,000.00 | Tomato | 5 |
2018-10-17 | Sophia | 95,000.00 | Eggplant | 7 |
2018-07-20 | Beah | 63,442.40 | Onion | 200 |
2018-05-11 | Christian | 400,400.00 | Chili | 50 |
2018-06-29 | Christine | 192,857.25 | Peanut | 12 |
2018-06-22 | Faye | 140,262.50 | Potato | 32 |
2018-10-17 | Mary Rose | 171,600.00 | Beans | 17 |
2018-10-24 | Christine | 111,540.00 | Tomato | 24 |
2018-05-11 | Irish | 139,776.00 | Eggplant | 28 |
2018-06-22 | Judy | 117,450.01 | Onion | 27 |
2018-08-31 | Judy | 78,450.01 | Chili | 26 |
2018-06-22 | Nathan | 130,605.00 | Peanut | 15 |
2018-08-31 | Hazel | 37,800.00 | Potato | 13 |
2018-05-24 | Sherlyn | 79,200.76 | Beans | 80 |
2018-06-26 | Sophia | 30,961.58 | Tomato | 100 |
2018-06-26 | Sherlyn | 63,300.00 | Eggplant | 150 |
2018-08-28 | Andy | 68,400.00 | Onion | 19 |
2018-08-28 | Jia | 26,000.00 | Chili | 22 |
2018-10-01 | Thirdy | 26,000.00 | Peanut | 28 |
2018-10-10 | Cheyenne | 22,100.00 | Potato | 37 |
2018-07-13 | Hiro | 130,000.00 | Beans | 38 |
2018-10-01 | Nathan | 50,260.01 | Tomato | 47 |
2018-10-16 | Pauline | 64,915.20 | Eggplant | 42 |
2018-07-13 | Jia | 64,621.76 | Onion | 29 |
2018-10-16 | Sherlyn | 63,300.00 | Chili | 28 |
2018-10-22 | Hazel | 37,800.00 | Peanut | 30 |
2017-11-03 | Judy | 166,387.50 | Potato | 7 |
2018-05-22 | Charise | 26,000.00 | Laurel leaves | 5 |
2018-07-02 | Sophia | 30,961.58 | Laurel leaves | 4 |
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |