Forum Discussion
Calculation Groups
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.
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
1 Reply
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