Forum Discussion

Luukvv93's avatar
Luukvv93
Icon for Helper II rankHelper II
7 years ago
Solved

Need your help on a calculated column

Hi,   I created a calculated column with the following formula   ShiftStart = VAR MinMaxDatumTijd = MIN(VirtualShift[MaxDatumTijd]) RETURN SWITCH( TRUE(); VirtualShift[Shift] = "D"; VirtualShift...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Luukvv93 

    Create a column

    Column =
SWITCH (
    TRUE (),
    Sheet5[Shift] = "D", Sheet5[MinDatumTijd],
    Sheet5[Shift] = "A", CALCULATE (
        MIN ( Sheet5[MaxDatumTijd] ),
        FILTER ( ALLEXCEPT ( Sheet5, Sheet5[Shiftdatum] ), Sheet5[Shift] = "D" )
    )
)

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Luukvv93 

Create a column

Column =
SWITCH (
    TRUE (),
    Sheet5[Shift] = "D", Sheet5[MinDatumTijd],
    Sheet5[Shift] = "A", CALCULATE (
        MIN ( Sheet5[MaxDatumTijd] ),
        FILTER ( ALLEXCEPT ( Sheet5, Sheet5[Shiftdatum] ), Sheet5[Shift] = "D" )
    )
)

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.