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

Hi, 

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

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

    Hello amaniramahi ,

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

    • amaniramahi's avatar
      amaniramahi
      Icon for Helper V rankHelper V
      4 years ago

      so check my other comment