If with multiple conditions

[mahnoor1279]

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")))

[Vijay_A_Verma · Accepted solution]

Use this

= SWITCH(TRUE(),'data'[hours]<7.25,"Partially",'data'[hours]>7.25,"Overbooked","Fully booked")