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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Elu
New Member

DAX calculations new column Quarter

Hi everbody,

 

I am currently learning the DAX calculations for the Power BI certification.

In the exercise a new column ''Quarter'' has to be created with the given snippet code: 

Year =
"FY" & YEAR('Date'[Date]) + IF(MONTH('Date'[Date]) > 6, 1)
 
I have tried to modify the code into:
Quarter =
"FY" & YEAR('Date'[Date]) + IF(MONTH('Date'[Date]) > 6, 1) & "Q1"
 
... but I dont get the same result as in the screenshot attached:

 

Bildschirmfoto 2023-03-29 um 14.25.57.png
Instead, my result is the following:
 
Bildschirmfoto 2023-03-29 um 14.30.08.png

 

How do I need to modify the code to do it correctly?

 

Any help is appreciated!

 

Best, 

Elu

 
2 REPLIES 2
Ameoch
New Member

@Elu  Hey! Could you help me with month formuła in this case? I'm not sure what I'm typing wrong. 
Thanks, Amelia

Uspace87
Resolver III
Resolver III

@Elu 

YEAR_Quarter_ =

VAR Quarter_ = SWITCH(
    TRUE(),
    QUARTER(Date_Table[Date])=1, " Q3",
    QUARTER(Date_Table[Date])=2, " Q4",
    QUARTER(Date_Table[Date])=3, " Q1",
    QUARTER(Date_Table[Date])=4, " Q2"
)

Return "FY " & YEAR(Date_Table[Date]) & Quarter_

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.