Forum Discussion
dax: custom time intelligence
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)
These columns need to go into your Calendar dimension table, not in the fact table.
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
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)
many thanks again, lbendlin.
seems ok wth me but let me take a look again & cfm if all is good to go.
krgds,
-nik
