Forum Discussion
Solved
Switch Measure
I need help to create a switch true measure from the grouping that I have in the table. For example If (table 1 Groupcode) is Apple return apple else return others
Hi gauravnarchal ,
I have created a simple, please refer to it to see if it helps you.
Create a measure.
Measure = SWITCH(TRUE(),MAX('Table 1'[Groupcode])="apple","apple","others")Or a column.
Column = SWITCH ( TRUE (), ( 'Table 1'[Groupcode] ) = "apple", "apple", "others" )And Greg_Deckler 's formula works well.
Measure 2 = VAR __GroupCode = MAX('Table 1'[Groupcode]) RETURN SWITCH(TRUE(), __GroupCode = "apple","apple", "others" )Or you can change it to a column.
Column 2 = VAR __GroupCode = ('Table 1'[Groupcode]) RETURN SWITCH(TRUE(), __GroupCode = "apple","apple", "others" )If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gauravnarchal In your query, you can use a Trim operation on the column (right-click, Transform, Trim).