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.

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

HI Greg_Deckler 

 

Thanks for answering. Could you come up with how the formula would look?