Skip to main content

    Power BI

    Needs Votes

    Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    Vote (29) Share
    Wyn Hopkins's profile image

    Wyn Hopkins on 09 Apr 2017 09:12:56

    The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month No and Fiscal year

    Comments (4)
    Wyn Hopkins's profile image Profile Picture

    Isaac Williams on 22 Mar 2023 15:23:12

    RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    This should be merged with an older idea on the same topic.https://ideas.powerbi.com/ideas/idea/?ideaid=c58ddf2d-959f-4618-a617-4937c730c224

    Wyn Hopkins's profile image Profile Picture

    Michael Hammons on 05 Dec 2021 16:50:08

    RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    Agreed, Tableau is so far ahead of Power BI on dates it's sad.

    Wyn Hopkins's profile image Profile Picture

    Lenzy Petty Jr on 13 May 2021 11:42:19

    RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    Tableau has had a fiscal calendar option for years. Makes it soooooo easy to work in fiscal dates. Tableau delivers a fiscal date solution out of the box. So, you don't spend hours in the difficult gymnastics of DAX or Power Query solutions trying to get a fiscal date view. I love Power BI, but hate the work and limitations of I face due to the lack of an easy built in fiscal calendar solution.

    Wyn Hopkins's profile image Profile Picture

    Lenzy Petty Jr on 13 May 2021 11:36:29

    RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    Tableau does a great job with fiscal dates. Power BI needs this. It takes far too much time to build mockup fiscal calendars, and even when you build them, they don't work with great Power BI's Analytics Pane tools like Forecasting or Anomaly detection.