Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week grouping

Hi guys,   I'm trying to group my dates by week and used the Grouping function and it worked ok. But I'd like to group by the week ending date and not by the week starting like it is doing right no...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try this Column.

    Column 2 = 
VAR __yearWeek = FORMAT( 'Calendar'[Date], "YYYYWW" )
RETURN
CALCULATE(
    MAX( 'Calendar'[Date] ),
    ALL( 'Calendar' ),
    FORMAT( 'Calendar'[Date], "YYYYWW" ) = __yearWeek
)
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you amitchandak but after WEEKDAY is calling another function or measure and doesn't allow me to call the table, do you know why? thanks!

Week End date = DATEADD('Compare Date'[Compare Date],7-1*WEEKDAY('Compare Date'[Compare Date]),DAY)

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Hope you have done changes required in formula to suite your table. Can you share formula, relation and error.