https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2100872#M47942 <P>hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="264353" data-lia-user-login="wdx223_Daniel" class="lia-mention lia-mention-user">wdx223_Daniel</a>&nbsp;</P><P>&nbsp;</P><P>When your refer to "<SPAN><EM>dCalendar[YearMonth]</EM>", you mean, in my case dCalendar[date]&nbsp; ( with day, month, year), or&nbsp;or do you want a table with year and month only?</SPAN></P><P><SPAN>tks your reply</SPAN></P><P>&nbsp;</P><P><SPAN>best regards</SPAN></P><P><SPAN><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="324348" data-lia-user-login="stericontrol" class="lia-mention lia-mention-user">stericontrol</a>&nbsp;</SPAN></P> Mon, 27 Sep 2021 17:20:06 GMT stericontrol 2021-09-27T17:20:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2089504#M47561 <P>Hi friends!</P><P>&nbsp;</P><P>I need to get the <STRONG>3 highest values for each product sold </STRONG>considering the<STRONG> last 4 months</STRONG> (or 6) from the date on that I am (today for example) and <STRONG>calculate the average</STRONG>.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>can anyone help me?</P> Tue, 21 Sep 2021 19:01:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2089504#M47561 stericontrol 2021-09-21T19:01:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2090010#M47569 <P>NewMeasure=AVERAGEX(TOPN(3,ALLSELECTED(dCalendar[YearMonth]),CALCULATE(SUM(FactTable[Amount]),KEEPFILTERS( <SPAN>DATESINPERIOD</SPAN><SPAN>(</SPAN><SPAN>'Calendar'[Date]</SPAN>,<SPAN>EOMONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()</SPAN>,<SPAN>0</SPAN><SPAN>)</SPAN>,-<SPAN>3</SPAN>,<SPAN>MONTH</SPAN><SPAN>))</SPAN>)),CALCULATE(SUM(FactTable[Amount])))</P> Wed, 22 Sep 2021 01:53:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2090010#M47569 wdx223_Daniel 2021-09-22T01:53:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2100872#M47942 <P>hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="264353" data-lia-user-login="wdx223_Daniel" class="lia-mention lia-mention-user">wdx223_Daniel</a>&nbsp;</P><P>&nbsp;</P><P>When your refer to "<SPAN><EM>dCalendar[YearMonth]</EM>", you mean, in my case dCalendar[date]&nbsp; ( with day, month, year), or&nbsp;or do you want a table with year and month only?</SPAN></P><P><SPAN>tks your reply</SPAN></P><P>&nbsp;</P><P><SPAN>best regards</SPAN></P><P><SPAN><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="324348" data-lia-user-login="stericontrol" class="lia-mention lia-mention-user">stericontrol</a>&nbsp;</SPAN></P> Mon, 27 Sep 2021 17:20:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-3-AVERAGE-OF-THE-PERIOD/m-p/2100872#M47942 stericontrol 2021-09-27T17:20:06Z