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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello,

 

Thank you for your information.

 

Best regards.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi Anonymous,

       

      Thanks for sharing your solution.

       

      Regards,
      Yuliana Gu