topic Re: DAX Statement: Conditional in DAX Commands and Tips

DAX Statement: Conditional

Anonymous — Sun, 20 Sep 2020 18:16:12 GMT

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 Schedule'[Asite Export Master.Date (WET)] ,

"On-Time" ,

IF(

'00_Master Schedule'[Design release date for Works Information] > '00_Master Schedule'[Asite Export Master.Date (WET)] ,

"Late" ,

IF(

'00_Master Schedule'[Design release date for Works Information] <= DATE(TODAY(), && '00_Master Schedule'[Stage 1: Design Upload] = "Not Released" , "Overdue"

))))

Re: DAX Statement: Conditional

nandic — Sun, 20 Sep 2020 19:05:28 GMT

Anonymous ,

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

You used function DATE(TODAY()), but date function expects these parameters: year, month, day so it results in error.

Re: DAX Statement: Conditional

amitchandak — Mon, 21 Sep 2020 04:22:42 GMT

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