https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3855305#M150628 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp;<BR />Thank you very very much <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Sat, 20 Apr 2024 06:18:35 GMT AdamMG 2024-04-20T06:18:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3854899#M150622 <P>Hi Everyone.<BR />I am trying to create a measure (must be measure) - moving/rolling average (2 or 5 results) for DupResult column.</P><P>My Table looks like<BR /><BR /></P><TABLE><TBODY><TR><TD>rowid</TD><TD>DupResult</TD><TD>OrigResult</TD></TR><TR><TD>213034</TD><TD>8.97</TD><TD>7.29</TD></TR><TR><TD>215470</TD><TD>7.88</TD><TD>9.81</TD></TR><TR><TD>219651</TD><TD>7.97</TD><TD>6.32</TD></TR><TR><TD>225171</TD><TD>7.62</TD><TD>9.91</TD></TR><TR><TD>233214</TD><TD>9.14</TD><TD>12.45</TD></TR><TR><TD>233264</TD><TD>8.62</TD><TD>11.75</TD></TR><TR><TD>238295</TD><TD>6.33</TD><TD>8.98</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help</P> Sat, 20 Apr 2024 00:45:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3854899#M150622 AdamMG 2024-04-20T00:45:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3855192#M150626 <P>Hi,</P> <P>Please check the below picture and the attached pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/dax/index-function-dax?wt.mc_id=DP-MVP-5004989" target="_blank">INDEX function (DAX) - DAX | Microsoft Learn</A></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/dax/window-function-dax?wt.mc_id=DP-MVP-5004989" target="_blank">WINDOW function (DAX) - DAX | Microsoft Learn</A></P> <P>&nbsp;</P> <LI-CODE lang="markup">2 rows moving avg DupResult: = VAR _previousrow = MAXX ( OFFSET ( -1, ALL ( data ), ORDERBY ( data[rowid], ASC ), , , MATCHBY ( data[rowid] ) ), data[rowid] ) VAR _t = WINDOW ( -1, REL, 0, REL, ALL ( data ), ORDERBY ( data[rowid], ASC ), , , MATCHBY ( data[rowid] ) ) RETURN IF ( _previousrow &lt;&gt; BLANK () &amp;&amp; HASONEVALUE ( data[rowid] ), AVERAGEX ( _t, data[DupResult] ) ) </LI-CODE> <P>&nbsp;</P> Sat, 20 Apr 2024 05:38:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3855192#M150626 Jihwan_Kim 2024-04-20T05:38:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3855305#M150628 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp;<BR />Thank you very very much <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Sat, 20 Apr 2024 06:18:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-moving-rolling-average/m-p/3855305#M150628 AdamMG 2024-04-20T06:18:35Z