Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Statement: Conditional

This is my first post for help as I am relativley new to PowerBI! Hoping this maybe a quick fix?    Test = IF( '00_Master Schedule'[Design release date for Works Information] <= '00_Master Sche...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Better to use Switch

    Test =
SWitch( True(), 
'00_Master Schedule'[Design release date for Works Information] <= '00_Master Schedule'[Asite Export Master.Date (WET)] ,
"On-Time" ,
'00_Master Schedule'[Design release date for Works Information] > '00_Master Schedule'[Asite Export Master.Date (WET)] ,
"Late" ,
'00_Master Schedule'[Design release date for Works Information] <= TODAY() && '00_Master Schedule'[Stage 1: Design Upload] = "Not Released" 
, "Overdue"
)
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Better to use Switch

Test =
SWitch( True(), 
'00_Master Schedule'[Design release date for Works Information] <= '00_Master Schedule'[Asite Export Master.Date (WET)] ,
"On-Time" ,
'00_Master Schedule'[Design release date for Works Information] > '00_Master Schedule'[Asite Export Master.Date (WET)] ,
"Late" ,
'00_Master Schedule'[Design release date for Works Information] <= TODAY() && '00_Master Schedule'[Stage 1: Design Upload] = "Not Released" 
, "Overdue"
)