Quick Answer: how a finance analyst gets the month-end pack into Power BI in two weeks
Give it ten working days at about an hour a day, one short video and one build task each, ending with your real P&L and budget-vs-actual pages in Power BI. You do not need a course, a certification or fluent DAX. You need a clean model of your ledger, a handful of measures, and two pages your finance director recognises.
That is the whole plan. Days 1 to 5 build the engine: get the trial balance in, shape it, model it, add a fiscal calendar, write the base measures. Days 6 to 10 build the pack: time intelligence, the P&L layout, budget vs actual, then security and refresh so it survives the next close without you.
Two rules make it work. Every day ends with something built on your own data, not the tutorial's sample file. And every video below was picked because its title names exactly the job of that day, so you watch it once, close it, and build.
Why finance reporting in Power BI is not Excel with a new skin
In Excel your pack is cells: a P&L tab with SUMIFS pointing at a data tab, a budget tab pasted in, variance as one cell minus another. In Power BI there are no cells to point at. There is a model of tables joined by keys, and measures that calculate on whatever the page filters to. Learn that shift first.
This is why experienced Excel people struggle in week one. You go looking for the cell where revenue lives and it does not exist. Revenue is a measure: sum the amount column for the accounts mapped to Revenue, under whatever month, entity or cost centre the page is showing. Write it once and it is right on every page, in every month.
Three things from your Excel pack carry over and get more important. Your chart of accounts becomes a dimension table. Your account mapping, the sheet that says which GL codes roll up to which P&L line, becomes the backbone of the model, with a sort order and a sign column. And your budget becomes a second fact table sitting next to actuals, joined through the same accounts and the same calendar.
One thing does not carry over: hand-adjusting a number in the output. If a line is wrong in Power BI, the fix belongs in the mapping table or the source, never in the visual. That feels slower the first time. By the second month-end it is the reason the pack takes minutes instead of a day.
If your Excel is shaky on Power Query or lookup logic, spend an evening on our one-week Excel plan for data analysis first. Everything below assumes you are comfortable in a spreadsheet.
Before Day 1: collect four files from your own close
Before you open a single video, pull four things out of last month's close: a trial balance or GL export by month, your chart of accounts, your account mapping to P&L lines, and the budget by account and month. Without your own data the plan turns into tutorial-watching, and tutorials do not ship packs.
Save them as plain exports into one folder. Excel or CSV both work. Do not tidy them by hand, because Day 2 is about letting Power Query do the tidying in a way it can repeat next month.
Also save last month's finished pack, the PDF or Excel that actually went to the finance director. That is your answer key. On Day 8 and Day 9 your Power BI numbers have to tie to it line by line, and any difference is either a mapping error or a sign error until proven otherwise.
Finally, write down your fiscal year start month and whether your periods are calendar months or a 4-4-5 style pattern. It decides how you build the date table on Day 4.
Week 1: build the model your pack will run on
Week 1 is five days of plumbing with nothing pretty to show: loading the ledger, shaping it with Power Query, a star schema with your accounts at the centre, a fiscal date table and your base measures. It is the week people want to skip, and it is the reason Week 2 takes hours rather than days.
Day 1: open Power BI Desktop and load the trial balance
Watch Kevin Stratvert's Power BI Tutorial for Beginners (Kevin Stratvert, 12:11). It is enough because today's job is orientation: where the data, model and report views are, how to get data in, and what a visual is. You will learn every deeper piece on its own day.
On your own data today: install Power BI Desktop, load your trial balance export, and drop a simple table visual on the page showing amount by account. Check the grand total against your export. If it does not tie, find out why now, while the model has one table in it.
Day 2: shape the ledger and budget with Power Query
Watch Chandoo's Power Query - Beginner to PRO Masterclass in 30 minutes (Chandoo, 35:17). It is enough because the title promises the beginner-to-confident path in one sitting, and finance data needs only the core moves: removing junk rows, fixing data types, and turning a wide month-by-column layout into rows.
On your own data today: load your budget, which almost certainly has months as columns, and unpivot it so each row is one account, one month, one amount. Do the same to the ledger if it is wide. Make sure account codes are text on both tables, so a leading zero does not break a join next week.
Day 3: build a star schema around your chart of accounts
Watch Chandoo's Learn Data Modelling & Star Schema for Power BI in 20 minutes (Chandoo, 21:55). It is enough because a month-end pack needs one simple shape: fact tables for actuals and budget, dimension tables for accounts, dates and cost centres. If you have eight more minutes, Guy in a Cube's Why Power BI loves a Star Schema (Guy in a Cube, 8:10) explains the reason behind it.
On your own data today: turn your account mapping into the accounts dimension. One row per GL account, with columns for P&L line, P&L section, a sort order number and a sign column of 1 or -1. Join both actuals and budget to it on account code. Never join actuals to budget directly; let them meet through the dimensions.
Day 4: add a date table that knows your fiscal year
Watch SQLBI's Creating a simple date table in Power BI (SQLBI, 7:50). It is enough because the title says simple, and simple is what you want: one row per day, marked as the date table, with the columns your pack filters on. Every MTD, QTD and YTD number in Week 2 depends on getting this right today.
On your own data today: build the date table, mark it as a date table, and join it to both actuals and budget. Add a fiscal year and fiscal period column using the start month you wrote down before Day 1. If your ledger posts by period rather than date, map each period to its last day so the join works.
Day 5: write the base measures
Watch Chandoo's Learn 80% of DAX in an Hour (with FREE sample file) (Chandoo, 1:02:21). It is the longest video in the plan and enough on its own, because the title promises the large, everyday part of DAX in one hour, which is exactly what a finance pack uses. Today is the only day that takes more than your hour.
On your own data today: write four measures and nothing else. A signed actual amount that multiplies by the sign column from your accounts table. A signed budget amount built the same way. Variance as actual minus budget. Variance percent using DIVIDE so a zero budget does not throw an error. Every later measure builds on these four.
Week 2: build the pack and hand it over
Week 2 turns the model into the month-end pack: CALCULATE, time intelligence for MTD, QTD and YTD, a P&L page that ties to last month's numbers, a budget-vs-actual page, then security and scheduled refresh. Each day ends with a page or a setting your finance director will actually see or rely on.
Day 6: understand CALCULATE before you need it
Watch Leila Gharani's DAX CALCULATE Function Made Easy to Understand (just one word) (Leila Gharani, 8:45). It is enough because CALCULATE is the function that changes which rows a measure looks at, and almost every finance measure after today is a CALCULATE wrapped around your Day 5 base measures.
On your own data today: write two measures with CALCULATE. Revenue only, filtered to the Revenue section of your accounts table. Operating expenses only, filtered the same way. Put both on a card visual, change the month on a slicer, and confirm both tie to last month's pack.
Day 7: add MTD, QTD and YTD
Watch Rahim Zulfiqar Ali's Time Intelligence DAX | Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY POWER BI (Rahim Zulfiqar Ali, 20:23). It is enough because its title lists every comparison a monthly pack needs, current, previous, same period last year, MTD, QTD and YTD, in one video.
On your own data today: write YTD actual and YTD budget, then prior year YTD if your ledger goes back far enough. If your fiscal year does not start in January, set the year-end date in your YTD measures, or your numbers will reset in the wrong month. Check one YTD figure against your Excel pack before writing the rest.
Day 8: build the P&L page
Watch PorcuBI's Profit and Loss Statement in Power BI - P&L - Financial Reporting (PorcuBI - Valerie Junk, 16:53). It is enough because the title is your exact deliverable: a P&L statement in Power BI. If you want a second angle, How to Power BI's How to Build a Financial Report in Power BI (How to Power BI, 23:06) covers the same job.
On your own data today: build a matrix with P&L line in rows, sorted by your sort order column, and actual, budget and variance in values. Add subtotal lines for gross profit and operating profit. Then tie every line to last month's pack. Any line that does not tie is a mapping or a sign problem; fix it in the accounts table, not the visual.
Day 9: build the budget-vs-actual page
Watch Goodly's Actual v/s Rolling Budget in Power BI (Goodly, 19:23). It is enough because the title names the page you are building today, and a rolling budget is the harder case, so a fixed annual budget becomes the easy version of the same idea.
On your own data today: build the budget-vs-actual page for the month and YTD side by side. Colour variance by whether it is favourable, which flips between revenue and expense lines, so lean on your sign column rather than writing two rules. Add a cost centre slicer. Show it to one budget holder and ask what they would read first.
Day 10: lock it down and set it to refresh
Watch Guy in a Cube's How to Setup Row-Level Security (RLS) in Power BI (Guy in a Cube, 5:04), then BI Tricks' How to Configure Schedule Refresh in Power BI (BI Tricks, 2:33). Together they are under eight minutes, and enough because today is two settings, not a new concept.
On your own data today: if budget holders should see only their own cost centres, set up a role that filters the cost centre table and test it with "view as". Publish the report and schedule its refresh for after your close timetable. If the source is a folder on your network, refresh usually needs a gateway, so ask IT which one to use. Then drop next month's export in and watch it update without you.
What to skip in these two weeks
Skip anything that does not get the P&L and budget-vs-actual pages out before close: the eight-hour full course, paid custom visuals, Premium features, and certification prep. Each one is real and useful in some other month. None of them makes your numbers tie to last month's pack, which is the only test that matters right now.
Luke Barousse's full course. Power BI for Data Analytics - Full Course for Beginners (Luke Barousse, 8:24:31) is a good course, and over eight hours long. Do not watch it end to end in two weeks. Treat it as reference: when one screen confuses you, find that chapter, watch it, close it.
Paid custom visuals. Paid visuals that promise a finance look are tempting. The built-in matrix and a well-sorted mapping table already produce a readable P&L. Add paid visuals after the pack works, if your finance director asks for something the matrix cannot do.
Premium features. Premium is a different licence tier built for bigger and wider deployments than one month-end pack. If someone mentions it, note it for after close and keep building on Desktop.
Certification prep. The PL-300 exam is a broad test of the whole tool, and studying for it now trades your deadline for a credential. If your role does require PL-300, our guide to the best YouTube channels for Power BI certification is the place to start once this close is behind you.
SQL, for now. If your ledger lives in a database, someone will eventually suggest querying it directly instead of exporting files. That is a good month-three project, and learning SQL from YouTube is a fair way in. It is not a two-week one.
What it costs to get the pack in front of colleagues
Building costs nothing: Microsoft's pricing page says Power BI Desktop is available as a free download. Sharing is the cost. Publishing and sharing reports with colleagues needs Power BI Pro, which Microsoft lists at $14.00 per user per month, paid yearly, checked October 2026. Premium Per User is listed at $24.00.
Before you buy anything, ask your IT team. Your company may already pay for Power BI licences as part of a wider Microsoft agreement, and they will know which workspace your finance reports should live in. Ask on Day 1, not Day 10, because licence requests can take longer than the build.
You do not need Premium Per User for a month-end pack. It is on the pricing page, and it is in the "What to skip" list above for the same reason.
Proof at the end: the pack you ship, plus the certificate
The proof that these ten days worked is not a quiz score. It is your month-end pack running in Power BI: a P&L page and a budget-vs-actual page that tie to last month's Excel numbers line by line, refresh on a schedule, and show each budget holder only their own cost centres.
Put three things in front of your finance director at the next close. The P&L page, with a note saying it ties to the old pack. The budget-vs-actual page, with variance coloured by whether it helps or hurts. And one sentence on how it updates: new exports land in the folder, the report refreshes, nobody rebuilds anything.
LearnPath builds a path of free YouTube videos for a topic and generates a quiz from each video's transcript, so you find out whether the watching stuck. Free opens step 1 of up to two paths; every later step is Pro, and the completion certificate is Pro-only, so free accounts do not get one. The certificate shows you finished a plan. The pack shows you can do the job.
Build a work-ready path on Power BI before your next month-end close.
Frequently Asked Questions
Six questions that come up when a finance analyst is handed Power BI and a close date. The short answers below point back to the day in the plan that covers each one in practice, so you can jump straight there when the question comes up in the middle of a build.
Can you learn Power BI in two weeks as a finance analyst?
Enough to ship your month-end pack, yes. Ten working days at about an hour each covers loading the ledger, building a star schema, a fiscal date table, the core DAX measures, a P&L layout and budget vs actual. It will not make you an expert, but it gets one report you understand into colleagues' hands before close.
Do I need to know DAX to build a P&L in Power BI?
Yes, but less of it than you fear. A month-end pack runs on a handful of measures: a signed amount, actuals, budget, variance, variance percent, and MTD, QTD and YTD versions of each. CALCULATE and a proper date table do most of the work. You can leave the rest of the language for later.
How do I handle revenue and expense signs in a Power BI P&L?
Decide once, in the model, not in each visual. In a typical trial balance export revenue is a credit, so it arrives negative. Add a sign column to your account mapping table, multiply by it in one base measure, and build every other measure on that base. Then a favourable variance means the same thing everywhere.
Do I need a Power BI Pro licence to share the report with my team?
To publish and share reports with colleagues, Microsoft's pricing page lists Power BI Pro at $14.00 per user per month, paid yearly, checked October 2026. Power BI Desktop itself is a free download, so you can build the whole pack first. Ask your IT team before buying anything, because your company may already pay for licences.
Should I watch a full Power BI course before month-end?
No. An eight-hour course is a reference, not a plan, when close is two weeks away. Watch one short video a day aimed at that day's job, then spend the rest of the hour building on your own ledger. Open the long course only when you are stuck on one specific screen.
Does LearnPath give a certificate for finishing a Power BI learning path?
Yes, on the Pro plan; free accounts do not get one. LearnPath builds a path of free YouTube videos for a topic and generates a quiz from each video's transcript. Free opens step 1 of up to two paths, and every later step is Pro. The real proof is still the month-end pack you ship.
