Forum Discussion

bgc200's avatar
bgc200
Regular Visitor
2 years ago

Calculation groups - timeintelligence and FX

Hello,   I'm trying to creata a model to calculate 2 things: - Timeintelligence functions - Currency translations   I used to do this through switches, where I have 2 FX types (source & actual)...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bgc200 ,

Based on the description, it is possible to create a new calculation group for fx calculations. Then, define calculation items for fx types.

You can view the following documents to learn more information.

Calculation groups in Analysis Services tabular models | Microsoft Learn

Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bgc200's avatar
bgc200
Regular Visitor
2 years ago

thanks for the reply!

 

Does this mean I can indeed have 2 different groups, 1 for the FX calculation and 1 for the time intelligence filtering?

 

Does my current solution with the FX translation as different calculated columns and then a separate sum measure for both work in this context?

Or do I need to do the FX calculation in the calculation group?

 

Lastly, what's the correct precedence order? 

First the time intelligence to filter my values table and then apply the FX translation calculation through a SUMX of Value * Related FXrate?