Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Use below formula in a custom column where #"Previous Step" should be your previous step
= List.Average(#"Previous Step"[Value])+10
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".
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!
Use below formula in a custom column where #"Previous Step" should be your previous step
= List.Average(#"Previous Step"[Value])+10
Very nice, thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.