Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

3 Different status

Hi Team,

I want my column based on my baseline value, if my Q1 is less than Baseline then No if it is equal to Baseline then Yes, if the Q1 is 0% then N/A.

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  Anonymous 

    Try to change you formula as below:

     

    Result = 
SWITCH (
    TRUE (),
    'Table'[Q1] = 0, "N/A",
    'Table'[Q1] < 'Table'[Base Line], "NO",
    'Table'[Q1] = 'Table'[Base Line], "YES"
)

     

     

    Best Regards,
    Community Support Team _ Eason

3 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Calculated column

    Result =
SWITCH( TRUE(), 0, "N/A", [Q1] < [Base Line], "NO", "YES" )
      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi,  Anonymous 

        Try to change you formula as below:

         

        Result = 
SWITCH (
    TRUE (),
    'Table'[Q1] = 0, "N/A",
    'Table'[Q1] < 'Table'[Base Line], "NO",
    'Table'[Q1] = 'Table'[Base Line], "YES"
)

         

         

        Best Regards,
        Community Support Team _ Eason