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 0134ss 2024-11-05T17:58:16Z 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="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="837698" data-lia-user-login="0134ss" class="lia-mention lia-mention-user">0134ss</a>&nbsp;,</P> <P>I created some data:</P> <P><img /></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><img /></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