Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
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...
Need Help
  • DebbieE's avatar
    DebbieE
    7 years ago
    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
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
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