Forum Discussion
Solved
Create a custom column in transform from table view
I have created a new column for my data under table view: 1 Exact Name = VAR CurrentCol = 'Aus'[Account Name] VAR _count = COUNTROWS( FILTER('Aus', 'Aus'[Account Name] = CurrentCol ...
Hi kellyylx
Please try this:
Here I create a set of sample:
In power query, click the Custom Column then paste the code:
let _currentAccountName = [Account Name] in if List.Count(List.Select( Source [Account Name],each _=_currentAccountName))>2 and [Active]="TRUE" then true else falseThe result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kellyylx ,
In addition to Kenneth447Steel suggested, in case if your column is of Boolean data type, you might have to slightly change the logic as below
let
CurrentCol = [Account Name],
_count = List.Count(List.Select(Source[Account Name], each _ = CurrentCol))
in
if _count >= 2 and [Active] = true then true else false
Regards,