Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If statement not working with columns, only taking measures

Hi everyone!   So I've been trying to use if statements to calculate a conditional column. I've been trying to create a column called shift, based on the hour an employee worked. So if they worked ...
Need Help
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous,

 

Do you mean something like this? 🙂

 

 

Right click on a column in your table and choose New Column:

 

Here the DAX:

ShiftString = 
SWITCH (
    TRUE,
    Table[Shift] = "1-6",  "Overnight Shift",
    Table[Shift] = "7-15", "Monring Shift",
    Table[Shift] = "16-0", "Evening Shift",
BLANK()
)

 

Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/