Forum Discussion
This Week vs Prior Week Daily Change
Hi everyone,
I want to create a line and clustered column chart with the following data:
Shared axis = Day (Monday through Sunday)
Column values = This Week and Prior Week
Line values = % Change (day this week vs same day last week)
The measures need to be able to handle a new year, e.g. if CurrentWeekNum = 1, PriorWeek = Max(Calendar[WeekNum]) && Year = CurrentYear - 1. My report currently has a calendar table with DayNum, WeekNum, etc. to handle this.
Here's an example of what I'm looking for in table form:
Any help would be greatly appreciated. Thank you!
bharri , This seem like a week behind clicks with help from date table
measures
This Day = CALCULATE(sum('Table'[Clicks]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
or
This Day = CALCULATE(sum('Table'[Clicks])))
7 behind = CALCULATE(SUM('Table'[Clicks]),dateadd('Date'[Date],-7,DAy))
also check
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9WOW
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
2 Replies
bharri , This seem like a week behind clicks with help from date table
measures
This Day = CALCULATE(sum('Table'[Clicks]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
or
This Day = CALCULATE(sum('Table'[Clicks])))
7 behind = CALCULATE(SUM('Table'[Clicks]),dateadd('Date'[Date],-7,DAy))
also check
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9WOW
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Perfect! Thank you for responding so quickly.
Just as an aside, is it possible to have Monday through Sunday always visible in the chart, filled with the prior week numbers?
Currently it's only showing Monday through Wednesday (today).
