12 month period.
1 Topic
Calculating average 12 month average
Hi Commnity I am seeking help to dynamically calculate average amount always for 12 months back. It needs to start from last month and then go 11 months back, meaning when currently in September, then the 12 month period should calculate average from August 2025 - September 2024. Start of next month it needs to start with September and so on. Also, im not sure if this is useful information but i have a fiscal year slicer in my report, but it needs to ignore the filter context on that one. Is there anyone who can come up with a sample code on how they would write the DAX for this. Thank you in advanceSolved1.3KViews0likes3Comments