Forum Discussion

zaza's avatar
zaza
Icon for Resolver III rankResolver III
6 years ago
Solved

Table.Profile sum based on another column

I'm stuck with something that seems very simple but for some reason I can't seem to be able to make it work.   I have the following table:   I create a new query in order to do a table prof...
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi zaza ,

try adjusting your statement like so:

 

 Table.Profile(Query3, {{"Custom", each Type.Is(_, type nullable number), each List.Sum(    List.Select( _, each _ = 1 )    )}})

 

 

zaza's avatar
zaza
Icon for Resolver III rankResolver III
6 years ago

Removed