Forum Discussion
Grouping dates into fortnights
Hi everyone,
I'm looking for a solution that will help in grouping dates into fortnights, irregardless of month or year. I'll attach an image to help understand what I am meaning.
It wouldn't matter if the column started at calendar start or a specific date.
The date table I have is just an invoked funtion in M.
Hopefully someone can help, I'm not sure what other information I could provide that would be helpful here.
I'm thinking:
Fortnight = VAR __BaseDate = DATE(2019,1,1) VAR __Days = ([Value].[Date] - __BaseDate) * 1. RETURN INT(__Days/20) + 1Attached PBIX.
2 Replies
- Greg_Deckler
Community Champion
I'm thinking:
Fortnight = VAR __BaseDate = DATE(2019,1,1) VAR __Days = ([Value].[Date] - __BaseDate) * 1. RETURN INT(__Days/20) + 1Attached PBIX.
RabiResolver I
Greg_Deckler , absolute genius, but instead of the number how can i get actual date of the fortnight