Forum Discussion
Table Layout Design, Production Schedule
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.
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
1 Reply
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