Forum Discussion
Calender table new change datasource
Hey Lea,
from my point of the view the best approach is the following:
1. Go to Power Query and import the new calendar table.
2. Modify the query that the new table looks like the old one (same structure, same columns, rename if necessary to have an identical table).
3. Go to the advanced editor and copy the query.
4. Go to the old table, open the advanced editor and paste the query of the new table.
5. Delete the query you created in step 2.
6. Close & Apply, you have successfully replaced your date table 🙂
7. Accept this answer as solution and give it a thumbs up 😉
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Hey Lea,
from my point of the view the best approach is the following:
1. Go to Power Query and import the new calendar table.
2. Modify the query that the new table looks like the old one (same structure, same columns, rename if necessary to have an identical table).
3. Go to the advanced editor and copy the query.
4. Go to the old table, open the advanced editor and paste the query of the new table.
5. Delete the query you created in step 2.
6. Close & Apply, you have successfully replaced your date table 🙂
7. Accept this answer as solution and give it a thumbs up 😉