Forum Discussion
Need help with creating a key index
Hello, So basically I have a FactSheet containing production data and I need to calculate the total shift time per production line. Each productionline follows a D (Day) shift and a A (Night)...
Hi again,
1. You are missing the filter function around the table argument in the MINX function
2. You should not compair the date column to the variable, but the Index column to the variable.
This is how it should be:
VAR index = IndexColumn
RETURNMINX(
FILTER(
Table,
IndexColumn = index
);
DateColumn
)Regards,
Kristjan
Hi again,
1. You are missing the filter function around the table argument in the MINX function
2. You should not compair the date column to the variable, but the Index column to the variable.
This is how it should be:
VAR index = IndexColumn
RETURN
MINX(
FILTER(
Table,
IndexColumn = index
);
DateColumn
)
Regards,
Kristjan
Fantastic it works thanks so much