topic Grouping dates into fortnights in DAX Commands and Tips

Grouping dates into fortnights

Anonymous — Wed, 26 Feb 2020 21:47:55 GMT

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.

Re: Grouping dates into fortnights

Greg_Deckler — Wed, 26 Feb 2020 22:08:30 GMT

I'm thinking:

Fortnight = VAR __BaseDate = DATE(2019,1,1) VAR __Days = ([Value].[Date] - __BaseDate) * 1. RETURN INT(__Days/20) + 1

Attached PBIX.

Re: Grouping dates into fortnights

Rabi — Wed, 29 Nov 2023 22:37:34 GMT

Greg_Deckler , absolute genius, but instead of the number how can i get actual date of the fortnight