Forum Discussion

hood2media's avatar
hood2media
Resolver II
2 years ago
Solved

dax: custom time intelligence

hi,   as an intro, i am doing analysis on flight performance data (specifically on the durations of actual flying, taxi-in, taxi-out, delays etc) for the past few years. in the airline industry, th...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    I simplified your calendar table a bit more and also introduced a season number.  Both for sorting the season title and for doing the time intelligence stuff.

     

    See attached for the example of using custom "SAMEPERIODLASTYEAR"  calculations. As you can see the total value is missing.  If you want that then you will have to totally rewrite the AVERAGE function (which kinda negates the calculation group)

     

     

hood2media's avatar
hood2media
Resolver II
2 years ago

tks lbendlin.

i hv corrected the calendar table (& also uploaded it to the same location in the weblink mentioned above).

i stil hope to find a way to getting the formula for a custom calculation group on the seasons for this case?

tks & kgrds,

-nik

lbendlin's avatar
lbendlin
Super User
2 years ago

I simplified your calendar table a bit more and also introduced a season number.  Both for sorting the season title and for doing the time intelligence stuff.

 

See attached for the example of using custom "SAMEPERIODLASTYEAR"  calculations. As you can see the total value is missing.  If you want that then you will have to totally rewrite the AVERAGE function (which kinda negates the calculation group)

 

 

  • hood2media's avatar
    hood2media
    Resolver II
    2 years ago

    many thanks again, lbendlin.

     

    seems ok wth me but let me take a look again & cfm if all is good to go.

     

    krgds,

    -nik