Forum Discussion

froxas's avatar
froxas
Helper II
6 years ago

make workload scheduler

Hi,   Here is production of furniture. I have in database operations. I can sum total hours needed to make orders for each operations. also i have resources availability per operation ped day. ...
Need Help
Fowmy's avatar
Fowmy
Super User
6 years ago

froxas 

Please add below measure:

I have added a calendar table but not linked to your orders table as you do not provide a date column there. Anyhow, check the following works for you.

You can download the file: HERE

Measure = 
VAR DP = 
    ROUNDUP(
        DIVIDE(
            SUM(Orders[WorkScope]),
            MAX(Operations[ResourcesInHoursPerDay])
        ),
        0
    )
VAR D = SELECTEDVALUE('Calendar'[Date])
VAR C = 
    CALCULATE(
        COUNTROWS('Calendar'),
        'Calendar'[Date] <= D,
        ALL('Calendar')
    )
RETURN

IF(
    DP < C,BLANK(),C
)

 

 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn