Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
I'm thinking:
Fortnight =
VAR __BaseDate = DATE(2019,1,1)
VAR __Days = ([Value].[Date] - __BaseDate) * 1.
RETURN
INT(__Days/20) + 1
Attached PBIX.
I'm thinking:
Fortnight =
VAR __BaseDate = DATE(2019,1,1)
VAR __Days = ([Value].[Date] - __BaseDate) * 1.
RETURN
INT(__Days/20) + 1
Attached PBIX.
@Greg_Deckler , absolute genius, but instead of the number how can i get actual date of the fortnight
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |