https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-average-of-a-balance-at-filter-date-month-end/m-p/4379800#M173861 <P>&nbsp;</P><P><STRONG>Identify Year-End</STRONG>: Dynamically calculate the closest June date before or equal to the selected month (e.g., jun-23 for oct-23).</P><P><STRONG>Fetch Balances</STRONG>: Get the balance for the selected month (e.g., oct 23) and the most recent year-end (e.g., jun 23).</P><P><STRONG>Calculate Average</STRONG>: Add the two balances and divide by 2.</P><P>&nbsp;</P> Fri, 24 Jan 2025 13:20:03 GMT Akash_Varuna 2025-01-24T13:20:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-average-of-a-balance-at-filter-date-month-end/m-p/3547073#M136406 <P>Assume y/e is Jun and current reporting or filter date is Oct-23. How do I calculate the simple average of a balance at at Oct-23 and as at Jun-23. I only have month-end values in table. Needs to be dianamic, i.e. if I filter on Sep-23, average to change to values as at Sep-24 and Jun-23 devided by 2.</P> Wed, 22 Nov 2023 15:42:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-average-of-a-balance-at-filter-date-month-end/m-p/3547073#M136406 NicoAbsil 2023-11-22T15:42:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-average-of-a-balance-at-filter-date-month-end/m-p/4379800#M173861 <P>&nbsp;</P><P><STRONG>Identify Year-End</STRONG>: Dynamically calculate the closest June date before or equal to the selected month (e.g., jun-23 for oct-23).</P><P><STRONG>Fetch Balances</STRONG>: Get the balance for the selected month (e.g., oct 23) and the most recent year-end (e.g., jun 23).</P><P><STRONG>Calculate Average</STRONG>: Add the two balances and divide by 2.</P><P>&nbsp;</P> Fri, 24 Jan 2025 13:20:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-average-of-a-balance-at-filter-date-month-end/m-p/4379800#M173861 Akash_Varuna 2025-01-24T13:20:03Z