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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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