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.
Hi every one,
I'm struck and really struggling to build a logic in power BI, I'm looking for a solution to reslove in power query or by writing DAX.
I had massaged data and it is in good shape now.
For e.g. current month is Febrauary 2022, so in the column "Curr Forecast" the values will start showing up from the current month to future months in the financial year i.e. from Feb 2022 to Jun 2022.
Now I need to calcualte current financial year forecast i.e. from July 2021 to June 2022.
Values that are highlighted in the above picture should show as a single column "Current FY forecast".
So the expected columns and vaues are shown in the report should be as per below screenshot:
OUTPUT:
1) Calculate "Current FY Forecast"
2) Calculate Variance ( "Current FY Forecast" - Actual)
Appreciate your ideas and help.
Thanks in advance
Dee
Solved! Go to Solution.
@Deeintu Fairly certain the first thing you will want to do is unpivot all of your forecasting columns.
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 |
---|---|
14 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |