Forum Discussion
Two IF condition based on measure
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
- This worked for me
Outcome =SWITCH(TRUE(),'Table'[Status]="N","Not Required",'Table'[Status]="Y" && [Measure]<TODAY(),"Non Compliant","Complaint")
5 Replies
Hi,
tbh I think we need you to elaborate..
the table above is the outcome or the table you have?Hello amaniramahi ,
First two columns are to be used while third column is what I am expecting the answer should be.
so check my other comment
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)- This worked for me
Outcome =SWITCH(TRUE(),'Table'[Status]="N","Not Required",'Table'[Status]="Y" && [Measure]<TODAY(),"Non Compliant","Complaint")
