Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 ReportingUser | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |