Multiple IF

Question

Hi and good day,Can anyone help me on my claculated columm using IF function (for ACTIVE Job only)&nbsp;- IF Job is ACTIVE, then check Est Stat Date if date is 2025&nbsp; 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&nbsp;Est End Date if&nbsp; 2025 copy the date on the result column&nbsp;&nbsp;DESIRED OUTPUTThank you

pankajnamekar25 · Accepted Answer

Hello&nbsp;AllanBerces&nbsp;Use this DAX code to create calculated columnResultDate =IF (&nbsp;&nbsp;&nbsp; 'Table'[Job Status] = "ACTIVE",&nbsp;&nbsp;&nbsp; SWITCH (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRUE(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YEAR('Table'[Est Stat Date]) = 2025, 'Table'[Est Stat Date],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YEAR('Table'[Actual Stat Date]) = 2025, 'Table'[Actual Stat Date],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YEAR('Table'[Est End Date]) = 2025, 'Table'[Est End Date],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BLANK()&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp; BLANK())&nbsp;Thanks,&nbsp;Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Forum Discussion

Multiple IF

2 Replies

Related content

MULTIPLE CARD

Multiple dataViewMappings

Merge data from multiple excel files from multiple sharepoint folders

Disable multiple eventstreams

IF, Multiple