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 All
Please can anyone assist or point me in the direction of how to create the following reports in Power BI
Are there any channels on YouTube or Microsoft videos that one can follow to create these reports.
I can create this in Excel however I would like to do this in PowerBI
Looking forward to getting feedback from the community
Many thanks
Solved! Go to Solution.
Hi @atin
1. Income statement - showing the Rolling forecast & prior year forecast including variances ( showing both monthly. 1/4ly, YTD & FY analysis)
Forward Forecasting Techniques in Power BI with DAX,
Running Increase of Forecast based on Actuals
Creating a Rolling Average Graph with Power BI
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
2. Balance sheet for the year
Calculate balance of account with accunt transactions table
Balanced Scorecards in Power BI
3. Cash flow model
Hi @atin
1. Income statement - showing the Rolling forecast & prior year forecast including variances ( showing both monthly. 1/4ly, YTD & FY analysis)
Forward Forecasting Techniques in Power BI with DAX,
Running Increase of Forecast based on Actuals
Creating a Rolling Average Graph with Power BI
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
2. Balance sheet for the year
Calculate balance of account with accunt transactions table
Balanced Scorecards in Power BI
3. Cash flow model
There are two resources you may want to check out.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |