Calculate simple Average of Column

[Rygar]

Dear Community,

this should be simple, but I dont know how to do it in M Language. Value is given, the second Column (Average of Column Value + 10) should be calculated:

Value	Average of Column Value + 10
10	30
20	30
30	30

Thanks and regards, Michael

[Vijay_A_Verma · Accepted solution]

Use below formula in a custom column where #"Previous Step" should be your previous step

= List.Average(#"Previous Step"[Value])+10

[AlexisOlson · Accepted solution]

It's generally better to do this sort of thing with a measure in DAX, but if you have to do it in the query editor, you can write a custom column like this:

You'll need to use whatever the previous step name was instead of #"Changed Type".

[Rygar]

This did it, thanks!

[Vijay_A_Verma · Accepted solution]

Use below formula in a custom column where #"Previous Step" should be your previous step

= List.Average(#"Previous Step"[Value])+10

[Rygar]

Very nice, thanks!