I have a measure that needs to meet the following conditions:
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
@Anonymous , Try a measure like
Rolling 4 = CALCULATE(SUM(Tasks[hours]) / 60,DATESINPERIOD('Date'[Date],maxx('DAte',STARTOFQUARTER( DATEADD('Date'[Date],-1,QUARTER)),4,QUARTER)) )
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.