Forum Discussion

JohannesBier's avatar
JohannesBier
Icon for Helper I rankHelper 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 i...
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
    )

JohannesBier's avatar
JohannesBier
Icon for Helper I rankHelper 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?

  • JohannesBier's avatar
    JohannesBier
    Icon for Helper I rankHelper I
    2 years ago

    Yes, PowerQuery would be perfect, the column should just change these few cells to "Weekend" if the Date Number = 4 and Shfit No = 3.