Forum Discussion

Hamdan1234's avatar
Hamdan1234
Icon for Helper III rankHelper III
4 years ago
Solved

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 Complia...
Need Help
  • Hamdan1234's avatar
    Hamdan1234
    4 years ago
    This worked for me
    Outcome =
    SWITCH(
    TRUE(),
    'Table'[Status]="N","Not Required",
    'Table'[Status]="Y" && [Measure]<TODAY(),"Non Compliant","Complaint")
amaniramahi's avatar
amaniramahi
Icon for Helper V rankHelper V
4 years ago

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)