Forum Discussion
Rygar
Helper II
Helper IICalculate 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 Col...
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".
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalUse below formula in a custom column where #"Previous Step" should be your previous step
= List.Average(#"Previous Step"[Value])+10
RygarHelper II
Helper IIVery nice, thanks!