Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good Morning,
So I have a table with the Schema as follows;
Added Date | Bookings Date | Total Price | Week No |
01/01/2022 | 05/06/2023 | 100 | LAST YEAR |
01/01/2023 | 01/05/2023 | 200 | 1 |
08/01/2023 | 01/04/2023 | 50 | 2 |
So I need to look at this week by week
Week 1 i need to return
Total Bookings | Added This Week | Increase % |
300 (Row 1 & 2) (Needs to include ALL bookings with a bookings date of 2023 but only up to Added date of the week in question | £200 (Row 2) | 200% Total Price for all bookings with bookings date added up to W1 / Total Price for all booking with bookings date added date up to Last week |
Week 2
Total Bookings | Added this week | Increase % |
£350 | £50 | 50/(350-50) = 16.66% |
I hope this makes sense, Its difficult due to the mutliple dates required, i cant get this to work with the calendar, as i need to be able to use the calendar weeks to present a dashboard.
Wouldn't week 1 be a 100% increase?
i cant get this to work with the calendar, as i need to be able to use the calendar weeks to present a dashboard.
how is that preventing you from using a calendar?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
60 | |
43 | |
40 |