make workload scheduler

[froxas]

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 

[v-kelly-msft]

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!

[Fowmy]

@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

[Fowmy]

@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

[froxas]

@Fowmy  added sample data

link to sample data 

[Fowmy]

@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