Hey, together


I have the following table in Excel, which I add in PowerPivot to the data model:

ID Created Started Finished
1 01.01.2019 01.01.2019 05.01.2019
2 02.01.2019 03.01.2019 08.01.2019
3 03.01.2019 03.01.2019 04.01.2019
4 03.01.2019 04.01.2019 08.01.2019
5 03.01.2019 04.01.2019 04.01.2019
6 04.01.2019 06.01.2019 04.01.2019

So I have a table with multiple columns of dates.
I would like to connect these now somehow with the calendar table of PowerPivot. But how?
It can only create an active connection. I connect everyone, crashed everything.


Would you create three separate tables with PowerQuery?


Which approaches are there?


Best Regards
Joshua