Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Johnce1607
Frequent Visitor

Comparing a Stats from a Table with dates needed to Filter

Good Morning, 

 

So I have a table with the Schema as follows;

Added DateBookings DateTotal PriceWeek No
01/01/202205/06/2023100LAST YEAR
01/01/202301/05/20232001
08/01/202301/04/2023502

 

So I need to look at this week by week

Week 1 i need to return 

Total BookingsAdded This WeekIncrease %
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 BookingsAdded this weekIncrease %
£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.

1 REPLY 1
lbendlin
Super User
Super User

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?

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.