Forum Discussion
Solved
Create a Rolling Current Quarter
Im trying to figure out how to add a rolling current quarter flag into my date dimension So we are now in June so it should be March April and May (take the last month as the start) Any sugge...
- Rolling Quarter Flag = IF(DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)<=3 && DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)>0,1,0)This seems to do the trick
Rolling Quarter Flag = IF(DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)<=3 && DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)>0,1,0)
This seems to do the trick