Skip to main content

Power BI

Completed

Quarter function in DAX

Vote (15) Share
PDB's profile image

PDB on 12 Jan 2018 09:42:03

Can we have a QUARTER function in DAX as per the YEAR or MONTH functions?

Administrator on 10 Jun 2021 18:51:33

This was since added

Comments (2)
PDB's profile image Profile Picture

Jan-Eric Ramberg on 05 Jul 2020 23:46:39

RE: Quarter function in DAX

Useful for more than financials. But could you have an optional argument specifying the first month in FY Q like Quarter[Date];7) sets Quarter 1 from July ??

PDB's profile image Profile Picture

Gregory J. Deckler on 05 Jul 2020 23:36:50

RE: Quarter function in DAX

I wrote a really simple one. https://community.powerbi.com/t5/Quick-Measures-Gallery/Quarter/m-p/391541