https://community.fabric.microsoft.com/t5/Developer/undefined/m-p/4271570#M58154 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/837698">@0134ss</a>&nbsp;,</P> <P>I created some data:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_0-1730857574961.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1194750i1D221B5A5AA91A20/image-size/medium?v=v2&amp;px=400" role="button" title="vyangliumsft_0-1730857574961.png" alt="vyangliumsft_0-1730857574961.png" /></span></P> <P>Here are the steps you can follow：</P> <P>1. Create measure.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Measure = var _today=TODAY() var _avgYTD= AVERAGEX( FILTER(ALL('Table'),'Table'[Date]&gt;=DATE(YEAR(_today),1,1)&amp;&amp;'Table'[Date]&lt;=_today),[Value]) var _avgall= AVERAGEX( ALL('Table'),[Value]) return DIVIDE(_avgYTD,_avgall)</LI-CODE> <P>&nbsp;</P> <P>2. Result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_1-1730857574962.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1194749i80DA83593F4EE6B4/image-size/medium?v=v2&amp;px=400" role="button" title="vyangliumsft_1-1730857574962.png" alt="vyangliumsft_1-1730857574962.png" /></span></P> <P>If the above results do not meet your expectations, you can express the expected results in the form of a picture, we can better help you!</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly</P> Wed, 06 Nov 2024 01:48:38 GMT Anonymous 2024-11-06T01:48:38Z https://community.fabric.microsoft.com/t5/Developer/undefined/m-p/4271166#M58151 <P>How to find Average YTD percentage using Dax&nbsp;</P> Tue, 05 Nov 2024 17:58:16 GMT https://community.fabric.microsoft.com/t5/Developer/undefined/m-p/4271166#M58151 0134ss 2024-11-05T17:58:16Z https://community.fabric.microsoft.com/t5/Developer/undefined/m-p/4271570#M58154 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/837698">@0134ss</a>&nbsp;,</P> <P>I created some data:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_0-1730857574961.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1194750i1D221B5A5AA91A20/image-size/medium?v=v2&amp;px=400" role="button" title="vyangliumsft_0-1730857574961.png" alt="vyangliumsft_0-1730857574961.png" /></span></P> <P>Here are the steps you can follow：</P> <P>1. Create measure.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Measure = var _today=TODAY() var _avgYTD= AVERAGEX( FILTER(ALL('Table'),'Table'[Date]&gt;=DATE(YEAR(_today),1,1)&amp;&amp;'Table'[Date]&lt;=_today),[Value]) var _avgall= AVERAGEX( ALL('Table'),[Value]) return DIVIDE(_avgYTD,_avgall)</LI-CODE> <P>&nbsp;</P> <P>2. Result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_1-1730857574962.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1194749i80DA83593F4EE6B4/image-size/medium?v=v2&amp;px=400" role="button" title="vyangliumsft_1-1730857574962.png" alt="vyangliumsft_1-1730857574962.png" /></span></P> <P>If the above results do not meet your expectations, you can express the expected results in the form of a picture, we can better help you!</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly</P> Wed, 06 Nov 2024 01:48:38 GMT https://community.fabric.microsoft.com/t5/Developer/undefined/m-p/4271570#M58154 Anonymous 2024-11-06T01:48:38Z