https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/quot-Between-quot-Slicer/m-p/1830862#M38918 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="180972" data-lia-user-login="arobinson" class="lia-mention lia-mention-user">arobinson</a>&nbsp;</P> <P>&nbsp;This should be very simple.&nbsp;Not sure I understand wht you need</P> <P>Create a measure:</P> <LI-CODE lang="markup">Measure = AVERAGE ( Table1[Overall Hours Goal] )</LI-CODE> <P>&nbsp;</P> <TABLE style="height: 100px; width: 100%; border-collapse: collapse; border-style: groove; border-color: #0c1c49; background-color: #00675f;" border="0" width="100%"> <TBODY> <TR style="height: 15px;"> <TD width="15.961305925030231%" style="width: 92px; height: 15px;"> <P><img /></P> </TD> <TD width="84.03869407496977%" style="width: 485px; height: 15px; text-align: left;"><FONT color="#FFFFFF"><SPAN style="color: #ffffff;"><STRONG>Please accept the solution when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></SPAN></FONT><FONT color="#FFFFFF"><SPAN style="color: #ffffff;">&nbsp;</SPAN> </FONT><BR /> <P><STRONG><FONT size="4.5" color="#FF99CC">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></STRONG></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 07 May 2021 20:25:49 GMT AlB 2021-05-07T20:25:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/quot-Between-quot-Slicer/m-p/1830773#M38917 <P>I am using a between slicer on my dashboard for dates.&nbsp;</P><P>&nbsp;</P><P>I am trying to average the Overall hours goal based on the dates selected in the slicer. I have tried so many different ways but nothing is helping.&nbsp; Anything will help.</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Fri, 07 May 2021 19:22:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/quot-Between-quot-Slicer/m-p/1830773#M38917 arobinson 2021-05-07T19:22:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/quot-Between-quot-Slicer/m-p/1830862#M38918 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="180972" data-lia-user-login="arobinson" class="lia-mention lia-mention-user">arobinson</a>&nbsp;</P> <P>&nbsp;This should be very simple.&nbsp;Not sure I understand wht you need</P> <P>Create a measure:</P> <LI-CODE lang="markup">Measure = AVERAGE ( Table1[Overall Hours Goal] )</LI-CODE> <P>&nbsp;</P> <TABLE style="height: 100px; width: 100%; border-collapse: collapse; border-style: groove; border-color: #0c1c49; background-color: #00675f;" border="0" width="100%"> <TBODY> <TR style="height: 15px;"> <TD width="15.961305925030231%" style="width: 92px; height: 15px;"> <P><img /></P> </TD> <TD width="84.03869407496977%" style="width: 485px; height: 15px; text-align: left;"><FONT color="#FFFFFF"><SPAN style="color: #ffffff;"><STRONG>Please accept the solution when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></SPAN></FONT><FONT color="#FFFFFF"><SPAN style="color: #ffffff;">&nbsp;</SPAN> </FONT><BR /> <P><STRONG><FONT size="4.5" color="#FF99CC">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></STRONG></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 07 May 2021 20:25:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/quot-Between-quot-Slicer/m-p/1830862#M38918 AlB 2021-05-07T20:25:49Z