Table with multiple date columns

[joslaz]

Hey, together


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

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Created[/TD]
[TD]Started[/TD]
[TD]Finished[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01.01.2019[/TD]
[TD]01.01.2019[/TD]
[TD]05.01.2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]02.01.2019[/TD]
[TD]03.01.2019[/TD]
[TD]08.01.2019[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]03.01.2019[/TD]
[TD]03.01.2019[/TD]
[TD]04.01.2019[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]03.01.2019[/TD]
[TD]04.01.2019[/TD]
[TD]08.01.2019[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]03.01.2019[/TD]
[TD]04.01.2019[/TD]
[TD]04.01.2019[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]04.01.2019[/TD]
[TD]06.01.2019[/TD]
[TD]04.01.2019[/TD]
[/TR]
</tbody>[/TABLE]

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