Forum Discussion
How can i summerize all values from one column in Power Query?
HI DBricklin1979 - Sorry my mistake, I was thinking of the syntax for a Group By function. You need to replace the "_" with the table name from the previous step. It would look like this:
= Table.AddColumn(#"Andrad typ", "Anpassad", each List.Sum( #"Andres typ"[Value] ) )
HI DBricklin1979 - Sorry my mistake, I was thinking of the syntax for a Group By function. You need to replace the "_" with the table name from the previous step. It would look like this:
= Table.AddColumn(#"Andrad typ", "Anpassad", each List.Sum( #"Andres typ"[Value] ) )
Perfect! It worked! Thanks Anonymous !
One question though; why do you write: # ?
The # is system break flag, it tell Power Query that the following is not "Text" but a reference to an Object called #"Text".
If your previous step had a simple name like Source, you don't use "". Power Query knows that your reference to the Source Step instead of "Source" text. But when the object has a complex name "Two Words", you need to add #"" to reference the object.
Me personally, I don't like one work step names for steps or queries (e.g. ThisStepDoesSomething). I prefer spaces (i.e. #"This Step Does Something"). The advantage is when using intellisence. If I start type with #" I will immediately see a list of items to scroll down and select. If you start type This it will still works, but some times the word is too similar to Power Query function, so the list contains other items.