Visual Calculations in Power BI - Calculating Moving Averages

[@unnikrishnansanthosh]

was expecting your tutorial, thank you for sharing

[@khajvand]

Thanks for sharing, useful

[@apamwamba]

if n=3 is moving backwards , what is n=-3 for the window size

[@apamwamba]

Ok i get it now.. n=3 i.e window size is basically like between current row and 2 preceding in standard sql.. 3 means backward. We are getting the same value for first current row because there are no backward values..

[@ExcelWithChris]

Hi. Can you please please assist me. I have seen in a previous video on UA-cam the following:
1. In power query you have your steps on the side.
2. At a specific point you get a result and want to put that data from that step into another query.
3. Then you just want to continue with the current query steps.
4. I know for example you can do a count of rows and then in the nest step you just reference the step before you counted the rows and get the data back and carry on - so what I want is instead of the count step, export the result of a step, get back and carry on.
Would be great if you could assist.
Regards
Chris (South Africa)

[@victorsanchez-wg1rz]

SALUDOS EKUATORIALES ANDINOS DESDE PUENGASI KITU

[@yhoefm]

Hello, thanks for the video, fyi there is also a problem on total level (9 Mio EUR) with the visual calculations, that is a major concern.

[@irynavilner4533]

Thank you, Mitchell! That's great overview with very useful example! Love it!

[@asche3350]

Thank U.I have been learning great things about dax