Forum Discussion
Solved
DAX Get Next 3 Consecutive Quarters
Hi,
I have a first order date for each customer. From there I can get Quarter and Year.
Now I need to get the next three consecutive Quarter/Year from that point. I'm going down the road o...
Got it.
Just had to add a new measure to get the first date in the quarter that the customer first date fell in
First Date In Quarter =
IF(ISBLANK([First Booking Date]),BLANK(),
DATE(YEAR(First Booking Date], ROUNDUP( DIVIDE( MONTH( [First Booking Date] ),3 ),0 ) *3 -2 1))
First Booking Date | First Date In Quarter
---------------------------------------------
5/1/2021 | 4/1/2021
Thanks,
-w
what about Time Intelligence functions like
DATEADD(calendar[date], 9, MONTH)