Multiple IF

[AllanBerces]

Hi and good day,

Can anyone help me on my claculated columm using IF function (for ACTIVE Job only)
 - IF Job is ACTIVE, then check Est Stat Date if date is 2025  copy the date on the result column
- IF Job is ACTIVE, then check Est Stat Date if date is not 2025 check on Actual Stat Date if 2025 copy the date on the result column
- IF Job is ACTIVE, then check Est Stat Date if date is not 2025 check on Actual Stat Date if not check Est End Date if  2025 copy the date on the result column
  

DESIRED OUTPUT

Thank you

[pankajnamekar25 · Accepted solution]

Hello @AllanBerces 

Use this DAX code to create calculated column

ResultDate =

IF (

    'Table'[Job Status] = "ACTIVE",

    SWITCH (

        TRUE(),

        YEAR('Table'[Est Stat Date]) = 2025, 'Table'[Est Stat Date],

        YEAR('Table'[Actual Stat Date]) = 2025, 'Table'[Actual Stat Date],

        YEAR('Table'[Est End Date]) = 2025, 'Table'[Est End Date],

        BLANK()

    ),

    BLANK()

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[AllanBerces]

Hi @pankajnamekar25 thank you very much for the reply, work as i need.