Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to show the predicted value of upcoming months based on the average of last 5 values. The regulatory year starts in April and Finishes in March.
The way I am calculating forecast value is the sum of the total value of months of current regulatory years and the last 5-year average value of remaining months.
For clarification, it would be like as follow
The predicted value of upcoming months = total value of current regulatory year + last 5 years average value of remaining months of the regulatory year.
For example, In April current regulatory year starts, so the predicted value of remaining months = actual value of April + last 5 years average value of remaining months (i.e. May to March).
I also don’t want to show the predicted value of months that are gone. For example, I don’t want to show the predicted value of April as it is gone.
To represent the above concept, I wrote the following measure:
The value of the last month of the current month is 7. So the predicted value of May should be 7 + 2.68 (based on last 5 year).
However, in the figure, it only shows 2.68, not 7+2.68.
Could anyone guide me where I am making the mistake? Sample file here
Solved! Go to Solution.
Hi @Dunner2020 ,
It's not very clear about your requirement based on the sample .pbix you provided:
So which result is not the one you wanna get?Can you explain more detailed according to your sample data?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Dunner2020 ,
It's not very clear about your requirement based on the sample .pbix you provided:
So which result is not the one you wanna get?Can you explain more detailed according to your sample data?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Dunner2020
I don't think this is a very complex task... but the description is a bit lacking in my opinion. This makes it harder than it should be to find the right solution. Could you please rephrase your narrative and make it clearer?
I have tried to rephrase. please have a look.
Hi @Dunner2020 ,
Is your issue solved now?If so,could you pls mark the reply as answered to close it?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |