Q? Calculation group with multiple dates table (Using tabular editor)

[crossboy]

Hi all,

With calculation group, how should we write DAX or setup for time intelligence analysis using multiple dates table (e.g. sales date, purchase date, inventory date)

For example (YTD Calculation)  :CALCULATE(SELECTEDMEASURE(), DATESYTD(DimDate[Date]))

Can DimDate[Date]) be dynamic? What is the most efficient solution?

Thanks for your suggestion.

[Anonymous]

HI @crossboy,

Time intelligence functions required a calendar table with active relationships.
If you want to use date fields form other tables to interact with current measure formula, you need to confirm they existed active relationships.

If you can't confirm the relationship mapping, I'd like to suggest you change to use date functions that allow you manually defined and filtered on the table that your formula calculated.

Time Intelligence "The Hard Way" (TITHW)  

Regards,

Xiaoxin Sheng

[amitchandak]

@crossboy , Check if,you can create inactive relation in the tabular edition. In Power BI we create multiple relations with date table and dates in fact and use userelation to activate them.

Example

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...