Hi, I thought I had this resolved. But starting in October it thinks November is the current QTR.
This is my DAX columns I created in the Calendar table.
These are the 3 columns i created
=IF(MONTH([DATES])-1=0,12,(MONTH([DATES])-1))
= ROUNDUP ([SORT]/3,0)
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<="" strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")....
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<="" strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")="" "<="" today(),if(roundup(month(today())="">=if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"")
Thoughts?
</today(),if(roundup(month(today())><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
</today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())>
This is my DAX columns I created in the Calendar table.
These are the 3 columns i created
=IF(MONTH([DATES])-1=0,12,(MONTH([DATES])-1))
= ROUNDUP ([SORT]/3,0)
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<="" strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")....
<today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")<="" strong=""><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")="" "<="" today(),if(roundup(month(today())="">=if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"")
Thoughts?
</today(),if(roundup(month(today())><today(),if(roundup(month(today()) 3,="" 0)="dCalendar[QTR],"CURRENT" qtd",""),"")
</today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())></today(),if(roundup(month(today())>
Last edited: