Hey, together
I have the following table in Excel, which I add in PowerPivot to the data model:
<tbody>
</tbody>
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
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 |
<tbody>
</tbody>
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