Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Time Intelligence AND Currency Selection in a Calculation Group

I have a model which currently utilises a FX currency lookup and overlays it with a Time Intelligence lookup. I want to use calculation groups to see if i can further optimise the model to replace all lookups in place of calculation groups.

I've successfully used a calculation group to create a series of items for time selection in Tabular Editor 2

I'd now like to overlay this with different possible scenarios for currency, so ideally i'd like to be able to have

  • one calculation group which calculates a base measure as either Native/Translated currency, depending on a users selection,
  • a second calculation group which performs time intelligence over that first group/item set.

    I've been looking this up and cant seem to find anything on the subject. is this even possible?