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

[PaulDBrown]

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

thanks!

[JoHo_BI · Accepted solution]

Hi Paul,

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

Try using this: 

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

Or in your case

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

Hope that helps!

[PaulDBrown]

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.

[v-huizhn-msft]

Hi @PaulDBrown,

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

Best Regards,
Angelia