Forum Discussion
Solved
If with multiple conditions
Hey everyone i want to make a bucket for entries
testing = if('data'[hours] = blank() && 'data'[hour] = 7.25 ,"partially",
if('data'[hours] >=7.25 "over booked","fully booked")))
Use this
= SWITCH(TRUE(),'data'[hours]<7.25,"Partially",'data'[hours]>7.25,"Overbooked","Fully booked")
1 Reply
Use this
= SWITCH(TRUE(),'data'[hours]<7.25,"Partially",'data'[hours]>7.25,"Overbooked","Fully booked")