cancel
Showing results for
Did you mean:
Highlighted
Senior Member

## What’s the equivalent of YEAR(TODAY()) for QUARTER?

Is there an Equivalent expression in DAX for YEAR(TODAY()) for QUARTER?

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: What’s the equivalent of YEAR(TODAY()) for QUARTER?

Hi Paul,

I don't think there's an equivalent, but you can create your own.

Try using this:

=ROUNDUP('Date'[Month] / 3,0)

=ROUNDUP(MONTH(TODAY()) / 3, 0)

Hope that helps!

3 REPLIES 3
Member

## Re: What’s the equivalent of YEAR(TODAY()) for QUARTER?

Hi Paul,

I don't think there's an equivalent, but you can create your own.

Try using this:

=ROUNDUP('Date'[Month] / 3,0)

=ROUNDUP(MONTH(TODAY()) / 3, 0)

Hope that helps!

Senior Member

## Re: What’s the equivalent of YEAR(TODAY()) for QUARTER?

Thanks @JoHo_BI,

I'll give them a try, though I was hoping something like this would be integrated into DAX. Seems strange it isn't.

Regards,

Paul.

Super Contributor

## Re: What’s the equivalent of YEAR(TODAY()) for QUARTER?

Hi @PaulDBrown,

Please follow the solution @JoHo_BI posted, and give us response if you have any other issue.

Best Regards,
Angelia

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 205 members 1,765 guests
Recent signins: