Forum Discussion

Narender's avatar
Narender
Resolver I
8 years ago
Solved

Add Quarter in Calender

Hi All, I need a quarter in my Report .  I have already a calender which I created via script as shown below.     Dates = GENERATE ( CALENDAR( DATE( YEAR( TODAY() ) - 4, MONTH( TODAY() ), DAY(...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago
        "Quarter" , "Q" & INT((MONTH(currentDay)/4)) + 1)
  • Narender's avatar
    Narender
    8 years ago

    Hi Phil,

     

    I did this, Which is working fine.

     

      VAR quarter  = CONCATENATE("Q",ROUNDUP(MONTH(currentDay)/3,0))

     

     

    Is it ok?

     

     

    Thanks,

     

    Narender

     

Narender's avatar
Narender
Resolver I
8 years ago

Hi Phil,

 

I did this, Which is working fine.

 

  VAR quarter  = CONCATENATE("Q",ROUNDUP(MONTH(currentDay)/3,0))

 

 

Is it ok?

 

 

Thanks,

 

Narender

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Nice, looks good.  Might pay to have a DateTime version of the column too so you get the full benefit on some visuals.

 

Something like 

 

Start of Quarter = 
    DATE
    (
    YEAR(currentDay) , 
    CONCATENATE("Q",ROUNDUP(MONTH(currentDay)/3,0)) ,
    1)