This Week vs Prior Week Daily Change

[bharri]

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!

[amitchandak · Accepted solution]

@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-5c324...

WOW

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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bharri]

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).