Forum Discussion

bharri's avatar
bharri
Frequent Visitor
5 years ago
Solved

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 = % Chan...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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-5c3243d1f9

 

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-Last-Week/ba-p/1051123
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's avatar
    bharri
    Frequent Visitor
    5 years ago

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