Forum Discussion
Issues with a previous 5 year average measure
Have struggled with this for ages so really could do with some advice; I am trying to create a measure to report the prevous 5 year average. I have tried different measure combinations with paral...
Hi gc27 ,
Based on the information you have provided, you can follow the steps below:
- Your fiscal year begins on 1 April and you may need to adjust your calculations to accurately reflect this. Please consider using the DATESINPERIOD function instead. See the following link for more details:
DATESINPERIOD function (DAX) - DAX | Microsoft Learn - Check that the slicer is affecting the data correctly to ensure that it is linking to the calendar table correctly and that the metrics are responding correctly.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the reply and apologies for the delay in mine.
I found a article online that discussed the differences between sameperiodlastyear, datediff and parallel period.
I cant remember which one i used but it produced the correct answer
Glad to hear you have resolved the issue.
Best Regards,
Ada Wang