Forum Discussion

kellyylx's avatar
kellyylx
Helper I
1 year ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 false

    The 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.

Kenneth447Steel's avatar
Kenneth447Steel
New Member
1 year ago

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
AddCustom

Apply and close to create the column. This allows you to append multiple tables with the new columns.