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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, thanks but does not work either.

This solution evaluates today and puts and Y if it´s in the last 7 days.

I need to put there max of week start in 7 days rolling periods.

from today to today -6 --> todays date

from day 6 to 14 --> day 6 date

from day 15 to 21 --> day 15 date

etc...

Thanks in advance

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for both resources, I had a quick view and they are very interesting, but does not match to my requirementes, finally I found a solution,:

    Max Week Date Last 7 Days =
    VAR __date = 'Calendar Cancelled'[Date]
    RETURN
    CALCULATE(MAX('Calendar Cancelled'[Date]); DATESINPERIOD('Calendar Cancelled'[Date];__date;+7;day))
    This groups by the top date of the current date + 7 days 🙂
    Thanks all for your help and sorry for the explanation, it is easy but I was lost.
    Aprreciatte your help