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

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