Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Using a new column, compile a yes or no value for column A based on values in Column B

Hi Everyone, I need to generate a new column in my report using DAX. This new column should contain a yes or no values for Column A based on the values in Column B. For clarity and with refer...

Need Help

TheoC

Community Champion

4 years ago

Hi Anonymous

You can use the following measure:

Measure = 

VAR _1 = COUNTROWS ( 'Table' )
RETURN
SWITCH ( 
    TRUE() ,
     _1 < 2 , "No" ,
     "Yes" )

Output is per below:

Hope this helps 🙂

Theo