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

Resources