Forum Discussion
ryan_b_fiting
Post Patron
Post PatronDate Grouping based on MOST RECENT dates
Hello Community - I am looking to create a 4 week grouping of data that is based off of the most recent date. By that I mean, I am looking to have 4 week groupings, but with the most recent 'group...
Try this calculated column:
4 Weeks Ended = VAR vMaxDate = MAX ( Sales[Period] ) VAR vDaysDiff = CONVERT ( vMaxDate - Sales[Period], INTEGER ) VAR vDelta = ROUNDDOWN ( DIVIDE ( vDaysDiff, 28 ), 0 ) VAR vResult = vMaxDate - ( vDelta * 28 ) RETURN vResult
Hi ryan_b_fiting ,
Has the problem be solved? Please consider to mark the answer as solution if it works for you.
Best Regards,
Jay
ryan_b_fitingAnonymous no this has not been solved. I have tried all the suggestions and a few others as well, but no luck yet.