This value at this exact hour, but 7 days before

[Anonymous]

Hi everyone! 🙂

I've run into a problem :s

So, I have a line chart, with the last 24 hours as x axis, and a count as values:

I want the same count, at the same hour, but 7 days before this hour.

For example,

At 10 AM in the graph, you see that the ligh blue value was around 60. What I need is: seven days before now (today, 10 AM), at 10 AM what was the count?

I'm sorry, this feels really confusing and I can't seem to find the answer.

Thank you in advance 🙂

[amitchandak]

In case you have date calendar configured. You can use 7 day before measure

7 days behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAY))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Hey!
Thanks for the reply.

I already did that and it outputs the same number on every datetime.