https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Allocating-Targets-Why-You-missed-these-Gems-closingbalancemonth/m-p/1247593#M575 <DIV data-block="true" data-editor="4fcud" data-offset-key="7t8ho-0-0"> <DIV data-offset-key="7t8ho-0-0">Closing Balance functions are not used too often -closingbalancemonth ,closingbalancequarter, closingbalanceyear. <DIV data-block="true" data-editor="4fcud" data-offset-key="8vev-0-0"> <DIV data-offset-key="8vev-0-0">These can help you analyze data without allocating.<BR /> <DIV data-offset-key="8vev-0-0">Discover usages of closingbalancemonth ,closingbalancequarter, closingbalanceyear with eomonth and lastnonblankvalue <DIV data-offset-key="8vev-0-0">&nbsp; <DIV data-offset-key="8vev-0-0"> <DIV data-block="true" data-editor="4fcud" data-offset-key="3i2li-0-0"> <DIV data-offset-key="3i2li-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax</A> <DIV data-block="true" data-editor="4fcud" data-offset-key="3iip3-0-0"> <DIV data-offset-key="3iip3-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalancequarter-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalancequarter-function-dax</A> <DIV data-block="true" data-editor="4fcud" data-offset-key="ele5r-0-0"> <DIV data-offset-key="ele5r-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax</A> <DIV data-offset-key="ele5r-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">&nbsp;</A> <P><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">Video : </A><A href="https://www.facebook.com/watch/?v=343509629992272" target="_blank" rel="noopener">https://www.facebook.com/watch/?v=343509629992272</A></P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <P><SPAN class="reportid hidden">eyJrIjoiMDJhYzdiMGEtMTQxZC00OGRhLWE4NmQtMzQwYjliN2E0MjQxIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9</SPAN></P> Thu, 01 Dec 2022 06:34:53 GMT amitchandak 2022-12-01T06:34:53Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Allocating-Targets-Why-You-missed-these-Gems-closingbalancemonth/m-p/1247593#M575 <DIV data-block="true" data-editor="4fcud" data-offset-key="7t8ho-0-0"> <DIV data-offset-key="7t8ho-0-0">Closing Balance functions are not used too often -closingbalancemonth ,closingbalancequarter, closingbalanceyear. <DIV data-block="true" data-editor="4fcud" data-offset-key="8vev-0-0"> <DIV data-offset-key="8vev-0-0">These can help you analyze data without allocating.<BR /> <DIV data-offset-key="8vev-0-0">Discover usages of closingbalancemonth ,closingbalancequarter, closingbalanceyear with eomonth and lastnonblankvalue <DIV data-offset-key="8vev-0-0">&nbsp; <DIV data-offset-key="8vev-0-0"> <DIV data-block="true" data-editor="4fcud" data-offset-key="3i2li-0-0"> <DIV data-offset-key="3i2li-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax</A> <DIV data-block="true" data-editor="4fcud" data-offset-key="3iip3-0-0"> <DIV data-offset-key="3iip3-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalancequarter-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalancequarter-function-dax</A> <DIV data-block="true" data-editor="4fcud" data-offset-key="ele5r-0-0"> <DIV data-offset-key="ele5r-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax</A> <DIV data-offset-key="ele5r-0-0"><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">&nbsp;</A> <P><A href="https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax" target="_blank" rel="noopener">Video : </A><A href="https://www.facebook.com/watch/?v=343509629992272" target="_blank" rel="noopener">https://www.facebook.com/watch/?v=343509629992272</A></P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <P><SPAN class="reportid hidden">eyJrIjoiMDJhYzdiMGEtMTQxZC00OGRhLWE4NmQtMzQwYjliN2E0MjQxIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9</SPAN></P> Thu, 01 Dec 2022 06:34:53 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Allocating-Targets-Why-You-missed-these-Gems-closingbalancemonth/m-p/1247593#M575 amitchandak 2022-12-01T06:34:53Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Allocating-Targets-Why-You-missed-these-Gems-closingbalancemonth/m-p/1300777#M593 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>,</P> <P>&nbsp;</P> <P>Saw your youtube video about the Allocating targets.</P> <P>&nbsp;</P> <P>How did you make the Quarterly target measure?</P> <P>&nbsp;</P> <P>I am in the process of making a quarterly report but i cant seem to figure out how to make my targets over a quarterly period.</P> <P>&nbsp;</P> <P>Could you send me the formula for the Quarterly Target please.</P> Mon, 17 Aug 2020 11:10:40 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Allocating-Targets-Why-You-missed-these-Gems-closingbalancemonth/m-p/1300777#M593 paulfink 2020-08-17T11:10:40Z