One data set, two date columns, one calendar table, relationship with multiple columns

[AnaR]

Hi all! I tried to search for somenthing first but couldn't find anything.

I'm trying to show on the same "Clustered column chart" visual the number of acquisition and cancellations but have been unlucky.

I've got one data set with two date columns (e.g. signup date and cancellation date); created a calendar table wich has a relationship with the signup date but then I'm unable to create a second relationship because it already has an active one.

Is there any other way of linking those two date columns to the calendar table? I've tried to create a second table to summarize the number of cancellations from the main data set so I could link to the calendar table but then when trying to plot, it does't work because it replaces it.

Thnak you,

Ana

[AnaR · Accepted solution]

 I finally found the answer: Power BI: HR Analytics - Employees as on Date - userelationship , crossfilter, Hired/Terminated - Yo...