Table Layout Design, Production Schedule

[Patrick90]

Hello, I have an issue with creating an appropriate table in Power BI, which is meant to serve as a production schedule for the upcoming days on a specific machine, outlining the next production run for each day and shift. I kindly request assistance in designing such a table. The data will be sourced from an Excel file, but I am uncertain about how to structure the table layout within Power BI.

I am attaching an example of how the production schedule table should look in Power BI.

[Anonymous · Accepted solution]

Hi @Patrick90 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create two dimension tables as below screenshot

Dimension table: MachineProduction

Dimension table: Sie

2. Create a measure as below to get the next production

NextProductionP = 
VAR _selmachine =
    SELECTEDVALUE ( 'MachineProduction'[Machine] )
VAR _selprod =
    SELECTEDVALUE ( 'MachineProduction'[Production] )
VAR _selsei =
    SELECTEDVALUE ( Sie[Sie] )
VAR _selshift =
    SELECTEDVALUE ( 'Plan'[Shift] )
RETURN
    CALCULATE (
        MAX ( 'Plan'[Next production] ),
        FILTER (
            'Plan',
            'Plan'[Machine] = _selmachine
                && SEARCH ( _selsei, 'Plan'[Start], 1, 0 ) > 0
        )
    )

3. Create a matrix visual as below screenshot

Best Regards