Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group Calendar Date by Last 7 Week Days Dynamically Calculate column

Hi Need to group dates into last 7 days of my calendar table in a column, I tryied with out luck and finally llooks I´m very close with this calculated column: First Day 7 Last Days = VAR toda...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

Not sure I got it, but you can get something like that

Rolling 7 = CALCULATE(Max(Sales[Sales Date]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-7,Day))

 

Where sales is my transaction table

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, nice idea but I tryied and does not work, I need a separate column in calendar table to use it in a chart to group data by this column.

I need it to create it whit out relation to a transaction table. 

This week start day needs to change every 7 days. Example for this week it´s 13-4-2020 for the last 7 days, after 7 days should be  the first day of the second group of 7 days,  etc...

This has to change everyday, your solution places the max value of transaction in all column 😞

Thanks anyway for your time