Two IF condition based on measure

[Hamdan1234]

I have a measure of Dax and I want to create another measure based on it. Below given table is measure  condition and outcome that should come. 

Measure	Status	Outcome
23/12/2021	Y	Compliant
02/11/2020	Y	Not Compliant
13/05/2021	N	Not Required
07/02/2021	N	Not Required
31/08/2020	Y	Not Compliant

I want if status is N the outcome should be Not required but If status is Y then it should go measure of date and check if date is less than today so Non compliant and if date measure is greater than today it should be compliant. Can anyone help? It would be really helpful.

Thanks

[Hamdan1234 · Accepted solution]

This worked for me
Outcome =

SWITCH(

TRUE(),

'Table'[Status]="N","Not Required",

'Table'[Status]="Y" && [Measure]<TODAY(),"Non Compliant","Complaint")

[amaniramahi]

or based on what I comprehended, here is the solution

Outcome = 
var CheckDate = if(Measure<today(),"Not Compliant","Compliant")
return
if(Status="N","Not Required",Outcome)

[amaniramahi]

Hi, 

tbh I think we need you to elaborate.. 
the table above is the outcome or the table you have?

[Hamdan1234]

Hello @amaniramahi ,

First two columns are to be used while third column is what I am expecting the answer should be.

[amaniramahi]

so check my other comment