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

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