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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can use time intelligence with a custom date table. Some functions won't be useful (DATESMTD for instance) if you're looking at seasons but if you have a date table that includes a column for season, there is a lot of time intelligence functionality you can use, and there are ways to write your own formulas that mimic the behavior of the out-of-the-box formulas that aren't available to you with seasons.