Forum Discussion
Create a custom column in transform from table view
I have created a new column for my data under table view:
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.
3 Replies
Hello!
To create the column in Power Query Editor, go to Home > Transform data. In the editor, select your table, then Add Column > Custom Column. Use this formula:
let
Source = ...,
AddCustom = Table.AddColumn(Source, "Exact Name", each
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
)
in
AddCustomApply and close to create the column. This allows you to append multiple tables with the new columns.
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 falseRegards,
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.
