Skip to main content

    Power BI

    Needs Votes

    Be able to define as a custom global setting a company fiscal year, month etc... and use this to convert any date field to fiscal

    Vote (22) Share
    's profile image

    on 04 Apr 2017 01:09:49

    currently we have no easy way to convert dates to fiscal calendar... you can using calculated columns, dax or lookup tables but its easy if you had a global setting for a quick definition and then call it on any visuals...

    Comments (2)
    's profile image Profile Picture

    Isaac Williams on 22 Mar 2023 14:28:33

    RE: Be able to define as a custom global setting a company fiscal year, month etc... and use this to convert any date field to fiscal

    This idea should be merged with an older suggestion that has more votes and covers the same topic.https://ideas.powerbi.com/ideas/idea/?ideaid=c58ddf2d-959f-4618-a617-4937c730c224

    's profile image Profile Picture

    tbrown on 05 Jul 2020 22:47:18

    RE: Be able to define as a custom global setting a company fiscal year, month etc... and use this to convert any date field to fiscal

    This might be great as some sort of quick measure.