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.

 

What i need to do, i need to convert it to matrix like below, where first column is operations, header is days and cells shows how many days for each operation is already occupied.

It means i need to make a calendar (lets say 1-2 moth infront) and according resources availability per day fill all these days with workload.

 

 

do somebody have ideas how it could be accomplished?

 

link to sample data 

Need Help

5 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    froxas 

    Can you share some sample data and the expected result?
    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
    ____________________________________
    How to paste sample data with your question?
    How to get your questions answered quickly?

    _____________________________________
    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

      • Fowmy's avatar
        Fowmy
        Super User
        6 years ago

        froxas 

        You need to have a column in the Orders table for the date that will indicate when each activity took place. This way, you can create a calendar a link with the date to visual in a matrix.


        You base measure needs to be modified as :

        DaysPlanned = 
ROUNDUP(
    DIVIDE(
    SUM(Orders[WorkScope]),
    MAX(Operations[ResourcesInHoursPerDay])
),
0)



        ________________________

        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

         

  • 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

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi froxas ，

     

    What does each cell in the matrix colored represent for?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!