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