Do I really need Multiple linked Calendars?

Question

I have an employee table with E#, hired&nbsp;Date, and term date.I would like to build a visual of hires and terms each month.I think I need to make 3 calendar tables to do this. 1 to link the start date to, 1 to link the term date and 1 more to link the 2.This seems wasteful, and that there must be an easier way.&nbsp;Help please.&nbsp;E#&nbsp; &nbsp; &nbsp; hired date&nbsp; &nbsp; termed date123&nbsp; &nbsp; &nbsp; 1/1/2018&nbsp; &nbsp; &nbsp; 11/15/2018234&nbsp; &nbsp; &nbsp; &nbsp;2/15/2018&nbsp; &nbsp; 8/20/2018...&nbsp;Month&nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; Feb&nbsp; &nbsp; &nbsp;Mar ...&nbsp; Aug&nbsp; &nbsp;Sep&nbsp; &nbsp;Oct&nbsp; &nbsp;Nov&nbsp; &nbsp;DecHire&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; 0Terms&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;

tommartens · Accepted Answer

Hey,
&nbsp;
I'm not sure if you're familiar with the concept of "role-playing" dimensions and how this concept can be modeled in SSAS Tabular or Power BI. This concept contradicts with the use of the DAX functions USERELATIONSHIP / TREATAS.
&nbsp;
But this article provides a good start:
http://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
&nbsp;
Regards,
Tom

Forum Discussion

Do I really need Multiple linked Calendars?

2 Replies

Related content

Multiple Calendars

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Multiple Calendars for Multiple Companies