Create a conditional column based on contents of data

This is a simple request. I have to create a column in query editor, or in table view. Whichever is easy. Column looks like this --> A,B,C,D,D,E,D B,C,D,B,D,A C,C,D,F,E,G D,D,E,E,E,F,B ...

Need Help

Show and Tell

tamerj1

3 years ago

hI DJKarma
Please refer to attached file with the solution

Result = 
VAR Items = SUBSTITUTE ( 'Table'[Column], ",", "|" )
VAR Length = PATHLENGTH ( Items )
VAR T1 = GENERATESERIES ( 1, Length, 1 )
VAR T2 = ADDCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
VAR T3 = GROUPBY ( T2, [@Item], "@Count", COUNTX ( CURRENTGROUP(), 1 ) )
VAR T4 = TOPN ( 1, T3, [@Count] )
VAR Result = MAXX ( T4, [@Item] )
RETURN
    IF ( PATHCONTAINS ( Items, "A" ), "A", Result )

Community 417.pbix26 KB