Skip to main content

    Power BI

    New

    If User can change default FISCAL YEAR starting month & end month

    Vote (25) Share
    Deepak's profile image

    Deepak on 06 Feb 2017 16:27:11

    I think BI calculate first quarter as Jan to Mar, but many country use FISCAL YEAR as April as starting month. If user want to change FISCAL YEAR starting month, its not easy to him.

    That's why I want suggest please make easier to this for users.

    Comments (1)
    Deepak's profile image Profile Picture

    f08f8be6 d6cf-4c7b-b3aa-730c65c2a5dd on 05 Jul 2020 23:46:45

    RE: If User can change default FISCAL YEAR starting month & end month

    Hi,

    An alternative though is to create a measure that sorts months. See below Code:

    Date Time Added Month Order = SWITCH(MONTH(CRM[Datetime Added]),
    6,1,7,2,8,3,9,4,10,5,11,6,12,7,MONTH(CRM[Datetime Added])+7)

    Status Chnage Date Month Order = SWITCH(MONTH(CRM[Status Chg Date]),
    9,1,10,2,11,3,12,4,MONTH(CRM[Status Chg Date])+4)

    But sadly you have to do this for each date field in your data set.

    it would be great if there is an option to specify the start of the Financial, Academic, or business year. For my University it starts on September.