I have a measure that needs to meet the following conditions:
- Sums the amount of hours for a task, where the starttime of the task is between
- The the first date of the previous quarter
- The last date of 3 quarters into the future
I'm so confused by the fact that DATEADD requires a vector format instead of a scalar, so I can't use the TODAY function.
The closest I've gotten is
Measure1 = CALCULATE(SUM(Tasks[hours]) / 60, DATESBETWEEN(Tasks[Startdate], FIRSTDATE(DATEADD(STARTOFQUARTER('Date'[Date]), -1, QUARTER)), LASTDATE(DATEADD(ENDOFQUARTER('Date'[Date]), 3,QUARTER))))
In this Measure the date table is a custom range of subsequent days similar to many other such tables found on this forum.
I hope someone can help me find a solution. Which might also include filters or slicers. I haven't gotten those to work because of my need for quarters, which aren't present in filters.
