Forum Discussion

AlessandraMacedo's avatar
AlessandraMacedo
Copper Contributor
Oct 01, 2020
Solved

POWER QUERY - NEW COLUMN

Hi I have to add new column in power query in "Base Usuario".   This new column must have this excel related formula: =COUNT.IFS('Base Integrantes'!AC:AC;"ATIVO";'Base Integrantes'!E:E;[@[Cod_UA]...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 01, 2020

    AlessandraMacedo 

    Another variant - make reference on lookup table, filter it on constant (ATIVO), add custom column with value 1

    Merge first table with it on E, expand ID column only

    and group on all columns but ID with SUM aggregation

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 01, 2020

AlessandraMacedo 

Another variant - make reference on lookup table, filter it on constant (ATIVO), add custom column with value 1

Merge first table with it on E, expand ID column only

and group on all columns but ID with SUM aggregation

Resources