Forum Discussion
Solved
Calculated Column: Count string within column
I want to be able to count within a table, the number of times a value appears within a column. For example i have the data below with 5 employees. And a [Hierarchy Path] string column. I want t...
Abawde1 ,
a new column
=
var _emp = [Employee]
return
countx(filter(Table, search(_emp, [Hierarhy Path],,0) >0) , [Employee])
Abawde1 ,
a new column
=
var _emp = [Employee]
return
countx(filter(Table, search(_emp, [Hierarhy Path],,0) >0) , [Employee])
Thank you amitchandak, works perfect