Skip to main content

    Power BI

    New

    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?

    Comments (2)
    PDB's profile image Profile Picture

    e6e8534c f5d2-4d31-b606-f74cdacc2b49 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

    a9528410 5438-48b6-a4bd-227f31374d70 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