Forum Discussion
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...
- Check out Week Starting. https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123
Greg_Deckler
Community Champion
Community ChampionYou might also want to review Sequential: https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
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