Solved: 3 different values

Anonymous · ‎07-21-2021

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.

Please help me

Jihwan_Kim · ‎07-21-2021

Result CC =
SWITCH (
TRUE (),
Data[Q1] = 0, "N/A",
Data[Q1] < Data[BaseLine], "No",
Data[Q1] = Data[BaseLine], "Yes"
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎07-21-2021

Result CC =
SWITCH (
TRUE (),
Data[Q1] = 0, "N/A",
Data[Q1] < Data[BaseLine], "No",
Data[Q1] = Data[BaseLine], "Yes"
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

3 different values