Hi @shompy08 ,
According to your description, here's my solution.
1.In Power Query, select all Floor columns at the same time(Ctrl+select).
2.Click Unpivot Columns tab under Transform ribbon.
3.Then select Extract Text Before Delimiter, enter a space in the Delimiter box.
Get this table.
4.In another table2, create a calculated column Month.
Month = FORMAT('Table2'[Date],"MMMM")
5.Create a measure.
% availability =
VAR _TimeNeeded =
MAXX (
FILTER (
ALL ( 'Table' ),
'Table'[Month] = MAX ( 'Table2'[Month] )
&& 'Table'[Plant] = MAX ( 'Table2'[Plant] )
),
'Table'[Hours]
)
RETURN
DIVIDE (
_TimeNeeded - MAX ( 'Table2'[Time out of service (in Hours)] ),
_TimeNeeded
)
Get the result. You can apply the visual filter to get % avaliability less than 90%.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Kaly, thanks for your help, you are very kind!
There is some mistake because the list is showing incorrect information. If you see in the example that you attached, every "Equipo" is repeated three times, one for every plant, which is incorrect.
If i want to show my boss a list of the "Equipos" for every plant and its calculate, it show all the equipments! I suppose this happen to with the dates by month.
And if you see the data, the code 3001045 belongs to "Toyota Hilux..." not to "Bomba Allweiler" as in the picture you can see.
Did i explain the error?
Thanks again for all you help!
Hi @shompy08 ,
I'm clear, for the current report, the problem can be solved by selecting the Planta column in the Notifications table, not in the Plants-Locations table.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
Dear Kaly, im affraid that is not correct!
If you see in the img and in the report, there are some equipments from another plants showed when the filter CVSA is activated.
Even, if you select another plant, the information showed in the table is the same, not change.
did i explain what i'm seeing?
Regards!
Dear, i have a little problem with the report.
When i publish in a table, i can't see all the equipments asociated with each plant. I suppose this happen because this equipment doesn't had a breakdown report (table 2) in the month but its works all the time that the plant need. (Hours needed)
If the equipment doesn't have a a report it has to appear in the table with 100% availability. Do you know how i can see this?
Here is an a example, in the left, the table has the formula for equipments of "PETN" plant that you show me, in the right, part of the full list of equipment for the "PETN" plant.
Did explain my problem? I need that the table showme the full list with the %, 100% if there was not breakdowns, and n% if the equipment had a breakdown in the month.
Thx in advance!
Hi @shompy08 ,
According to your description, here's my solution.
1.In Power Query, select all Floor columns at the same time(Ctrl+select).
2.Click Unpivot Columns tab under Transform ribbon.
3.Then select Extract Text Before Delimiter, enter a space in the Delimiter box.
Get this table.
4.In another table2, create a calculated column Month.
Month = FORMAT('Table2'[Date],"MMMM")5.Create a measure.
% availability =
VAR _TimeNeeded =
MAXX (
FILTER (
ALL ( 'Table' ),
'Table'[Month] = MAX ( 'Table2'[Month] )
&& 'Table'[Plant] = MAX ( 'Table2'[Plant] )
),
'Table'[Hours]
)
RETURN
DIVIDE (
_TimeNeeded - MAX ( 'Table2'[Time out of service (in Hours)] ),
_TimeNeeded
)
Get the result. You can apply the visual filter to get % avaliability less than 90%.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
