Forum Discussion
Calculate simple Average of Column
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
Use below formula in a custom column where #"Previous Step" should be your previous step
= List.Average(#"Previous Step"[Value])+10It'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".
4 Replies
Use below formula in a custom column where #"Previous Step" should be your previous step
= List.Average(#"Previous Step"[Value])+10Very nice, thanks!
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".
This did it, thanks!
