Forum Discussion

JohannesBier's avatar
JohannesBier
Helper I
2 years ago
Solved

Conditional column

Hello everyone,

I need help with a conditional column. I have a column with weekday (0-6) and shift number (1-3). The conditional column currently makes the distinction between week and weekend so it writes weekday 5 and 6 in the new column weekend. Now I would also like to add weekday 4, but only shift 3 to the conditional column. Unfortunately, I can't find an option with a double condition. Can anyone help me with this problem?

 

Best regards

Johannes

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    In your FILTER, you can use && to have 2 different filter conditions:
    VAR WorkingDayShift = 
      FILTER( ALL (Date ),
        'Date'[Working Day]  = 1 && 'Date'[Shift Number] = 3
    )

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    In your FILTER, you can use && to have 2 different filter conditions:
    VAR WorkingDayShift = 
      FILTER( ALL (Date ),
        'Date'[Working Day]  = 1 && 'Date'[Shift Number] = 3
    )

    • JohannesBier's avatar
      JohannesBier
      Helper I
      2 years ago

      The Code of the conditional column is = Table.AddColumn(#"Hinzugefügte benutzerdefinierte Spalte", "Tagestyp", each if [#"Wochentag Nr."] = 5 then "Wochenende" else if [#"Wochentag Nr."] = 6 then "Wochenende" else "Woche") Can you explain me, how to put the code in correctly?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        The code I was showing was for a Calculated Column. The code you are showing is for M code (In Power Query). Is that where you want the column?