Create a custom column in transform from table view

[kellyylx]

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

    )

)

RETURN IF(_count >= 2 && 'Aus'[Active]="TRUE", true, false)

I want to create this column under transform data instead as i want to append multiple tables with new columns after. 

How can I do so?

[Anonymous · Accepted solution]

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.

[Thejeswar]

@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,

[Kenneth447Steel]

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.