Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Time Intelligence for seasons

Hello,   Is it possible to perform calculations with the Time Intelligence functions with seasons? In my case, the season begins on September 1 and ends on August 31.   I would like to obtain t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi v-yulgu-msft,

     

    I've solved the issue by creating a calendar table with a seasonal column. Then I used the following formula to get the accumulated balances of the different seasons:

     

    Saldo acumulado = CALCULATE(SUM(ACCOUNT_INFORMATION[SUM$Amount]);
                                                        FILTER(

                                                                    ALL('Calendar');

                                                                    'Calendar'[NumTemporada]<=MAX('Calendar'[NumTemporada])

    )

    )

     

    Thank you very much and best regards.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Have you resolved your issue? If yes, please kindly mark the corresponding reply as an answer so that it can benefit more people. If you still have any question, please feel free to ask.

 

Best regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-yulgu-msft,

 

I've solved the issue by creating a calendar table with a seasonal column. Then I used the following formula to get the accumulated balances of the different seasons:

 

Saldo acumulado = CALCULATE(SUM(ACCOUNT_INFORMATION[SUM$Amount]);
                                                    FILTER(

                                                                ALL('Calendar');

                                                                'Calendar'[NumTemporada]<=MAX('Calendar'[NumTemporada])

)

)

 

Thank you very much and best regards.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    Thanks for sharing your solution.

     

    Regards,
    Yuliana Gu