Hi, I need to aggregate data by week and I see problem doing this. I could use function endweek(date) and solve the problem but when I do this I get problem with the month analysis, becuse the end week could be on different month. One example is 201006 where we have week 26 and 27.
Is there a way to use the ordinary weeks and set the end weeks for every new month ?
Can we do some this like, if the weekend of you transaction date is not equal to the current month then you could use month end function to calculate the date. Have a look at the below expression.
