Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Good Evening,
Im looking to create a % increase in Week on Week performance, But the weeks must be a running total of the year to date
See below, I would need in W7 to get a % increase from W6 to W7. Below shows a basic
Many thanks for your help in advance
Solved! Go to Solution.
Hi,
Assuming Week numbers on the X-axis have been dragged from the Calendar table and there is a relationship (Many to One and Single) from the Date column Booking table to the Date column of the Calendar Table, write these measures:
TP = SUM(Booking[Total Price])
TP YTD = calculate([tp],datesytd(calendar[date],"31/12"))
TP YTD till last week = calculate([tp tyd],datesbetween(calendar[date],min(calendar[date])-7,min(calendar[date])-1))
Growth (%) = divide(([TP YTD]-[TP YTD till last week]),[TP YTD till last week])
Hope this helps.
Perfect, thank you. Only thing it doesnt do is exlucde the calc on the first week of the year, so brings in the full year from before, Is there a way to exlclude this?
Hi,
Assuming Week numbers on the X-axis have been dragged from the Calendar table and there is a relationship (Many to One and Single) from the Date column Booking table to the Date column of the Calendar Table, write these measures:
TP = SUM(Booking[Total Price])
TP YTD = calculate([tp],datesytd(calendar[date],"31/12"))
TP YTD till last week = calculate([tp tyd],datesbetween(calendar[date],min(calendar[date])-7,min(calendar[date])-1))
Growth (%) = divide(([TP YTD]-[TP YTD till last week]),[TP YTD till last week])
Hope this helps.
Perfect, thank you. Only thing it doesnt do is exlucde the calc on the first week of the year, so brings in the full year from before, Is there a way to exlclude this?
You are welcome. Does this measure work?
TP YTD till last week = if(Calendar[Week]="W1",blank(),calculate([tp tyd],datesbetween(calendar[date],min(calendar[date])-7,min(calendar[date])-1)))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |