Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

creating date/calendar table

Hi all,  need some advice here, i am trying to follow the steps here https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/ but got this error: The following syntax error ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You may need to change the syntax "– 1" to "-1" in your formula in English input format, then it will work well.

     

    FYMonthNum = 
    VAR FYStartMonth = 4 
    //Update the fiscal year starting month above *Use number between 1 to 12 

    RETURN IF ( MONTH ( 'Date'[Date]) >= FYStartMonth, 
    MONTH ( 'Date'[Date] )- ( FYStartMonth -1 ), 
    12 + (MONTH ( 'Date'[Date] ) - (FYStartMonth -1 ) ) )

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You may need to change the syntax "– 1" to "-1" in your formula in English input format, then it will work well.

 

FYMonthNum = 
VAR FYStartMonth = 4 
//Update the fiscal year starting month above *Use number between 1 to 12 

RETURN IF ( MONTH ( 'Date'[Date]) >= FYStartMonth, 
MONTH ( 'Date'[Date] )- ( FYStartMonth -1 ), 
12 + (MONTH ( 'Date'[Date] ) - (FYStartMonth -1 ) ) )

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.