Forum Discussion
Solved
Grouping by Column Contains?
My data looks somethng like this... Transaction # Type Code Type (Desired Column) 12 1000 Long Long Term 12 101 Theatre Long Term 12 1900 Baseball Long Term 99 104 T...
chq , Please find the link to pbix. Minor chnage in column formula
https://www.dropbox.com/s/ghbeh6z55erxdtd/GroupTeam.pbix?dl=0
chq , create a new column like
New column =
var _1 = countX(filter(table,[Transaction #]=earlier([Transaction #]) && [Type]="Type"),[Transaction #])
return
if(isblank(_1) || _1 =0,[Type],"Long Term")
@amitchandak Would this be able to apply to multiple types, for example if it doesn't contain Long or Baseball but does contain Theatre then it equals Theatre?