Forum Discussion

kellyylx's avatar
kellyylx
Icon for Helper I rankHelper I
2 years 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
    2 years 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.

Anonymous's avatar
Anonymous
Not applicable
2 years 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.