Time interval with 7 days calculation

Question

Hello Everyone,&nbsp;I am new to power BI, Please help me, I want my chart to be like below,&nbsp;The time interaval for the chart is from ( 03/26(today) to 12/13 ) ( 15 interval total )each bar is having 7 days data ( sum(measure) for 7 days )first bar shows the 7 days of data next bar starts from 8th day&nbsp;&nbsp;please help me creating calculation for the same&nbsp;&nbsp;Thanks a lot in advance&nbsp;&nbsp;&nbsp;RegardsSV

greg_deckler · Answer

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

amitchandak · Answer

Are these dynamic buckets based on date

anonymous · Answer

Thanks for the reply amitchandak&nbsp;, yes these buckets are dynamic start always with today&nbsp;RegradsSV

amitchandak · Answer

I created this table, this start today and bucket is created for the next 7 days. Join with your date and try.
&nbsp;

anonymous · Answer

Anonymous&nbsp;If you want to get sum of previous 7 days, you can use the following measure, I also have it in column in the pibx.Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),SUMX(FILTER('Table',EARLIER('Table'[Date])&lt;='Table'[Date]&amp;&amp; EARLIER('Table'[Date])&gt;='Table'[Date]-6),'Table'[Value])))​But if you want to get date sliced by 7 days, you could just use Group dates.&nbsp;I put them in a sample pbix, try combine it with your own data.https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/EcPRCtKVm35Mo-ZPi8LAgE0B1Miwga1k7OocoB0SH6uLCA?e=g74CYL&nbsp;Paul ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Time interval with 7 days calculation

6 Replies

Related content

TIme Interval Calculation

calculating time

Time Interval Grouping

Scheduling a Microsoft Fabric Pipeline with Specific Time Intervals

Overlapping Time Intervals