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)

     

     

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