Forum Discussion
cutom column
I want to add a custom column in the power query editor to get output for the count of rows of the "Text" column. Example as shown below... Text Custom column AAACCC 3 AAACCC 3 A...
You can use this
= List.Count(List.Select(List.Buffer(Source[Text]), (x)=>x=[Text]))
Thanks, it works for me.