Calculation Groups

[Anonymous]

Hi @marcorusso 

Is it possible to write Dax Expression that works with Dynamic Dates in Calculation Groups ?

I have multiple Date Dimensions in my model due to various bussiness reasons. I would like to create single calculation Group that works irrespective of Date Dimension and Measures. 

I can able to write for measures.

I couldn't find article about this in SQLBI website.

[marcorusso · Accepted solution]

You should use one Date table and multiple relationships. We'll publish an article about how to switch the active relationship using calculation groups next week (Tuesday, Dec. 😎 on www.sqlbi.com
EDIT: the article is now available: Using calculation groups to switch between dates - SQLBI