Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Narender
Resolver I
Resolver I

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( TODAY()) ), TODAY()),
VAR startOfWeek = 1 // Where 1 is Sunday and 7 is Saturday, thus a 3 would be Tuesday
VAR currentDay = [Date]
VAR days = DAY( currentDay )
VAR months = MONTH ( currentDay )
VAR years = YEAR ( currentDay )
VAR nowYear = YEAR( TODAY() )
VAR nowMonth = MONTH( TODAY() )
VAR MonthName = FORMAT(DATE(2016,MONTH(currentDay),1),"MMMM")
VAR dayIndex = DATEDIFF( currentDay, TODAY(), DAY) * -1
VAR todayNum = WEEKDAY( TODAY() )
VAR weekIndex = INT( ROUNDDOWN( ( dayIndex + -1 * IF( todayNum + startOfWeek <= 6, todayNum + startOfWeek, todayNum + startOfWeek - 7 )) / 7, 0 ) )
RETURN ROW (
"Day", days,
"Month", months,
"Month Name",MonthName,
"Year", years,
"Day Index", dayIndex,
"Week Index", weekIndex,
"Month Index", INT( (years - nowYear ) * 12 + months - nowMonth ),
"Year Index", INT( years - nowYear )
)
)

 

Please tell me , how can I add Querter in script.

 

Thanks,

 

Narender

2 ACCEPTED SOLUTIONS
Phil_Seamark
Employee
Employee

    "Quarter" , "Q" & INT((MONTH(currentDay)/4)) + 1)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Hi Phil,

 

I did this, Which is working fine.

 

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

 

 

Is it ok?

 

 

Thanks,

 

Narender

 

View solution in original post

3 REPLIES 3
Phil_Seamark
Employee
Employee

    "Quarter" , "Q" & INT((MONTH(currentDay)/4)) + 1)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi Phil,

 

I did this, Which is working fine.

 

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

 

 

Is it ok?

 

 

Thanks,

 

Narender

 

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)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.