topic Re: Help with DAX formula in forecasting manpower in DAX Commands and Tips

Help with DAX formula in forecasting manpower

daciga — Sun, 10 Nov 2019 09:20:34 GMT

Hello people, I have this problem. I have a table with the following:

Sales
Staff (manpower)
Date
Item Sold

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.

Re: Help with DAX formula in forecasting manpower

daciga — Sun, 10 Nov 2019 12:12:48 GMT

Paging @Nathaniel_C.

Can you help me out with this roblem of mine. Thank you

Re: Help with DAX formula in forecasting manpower

Nathaniel_C — Mon, 11 Nov 2019 02:58:47 GMT

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

Re: Help with DAX formula in forecasting manpower

daciga — Wed, 13 Nov 2019 14:16:17 GMT

Hello Nathaniel_C ,

Good evening from the Philippines. Here is the sample data in excel format. Apologies for the late reply.

Dennis

employee_forecasting

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