Forum Discussion
Using Multiple Identical Data Sets for the Same Visuals
- 6 years ago
You can append the data
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
if needed
https://radacad.com/pivot-and-unpivot-with-power-bi
Preferably convert Month into month start or end date and use date dimension that will make time intelligence easy.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Appreciate your Kudos. mark me with @ for more information
Hi Anonymous ,
Yes, append queries is an easiest and fastest way to achieve it:
Go to Home>edit queries:
You can choose append queries as new if you wanna keep the previous queries:
Here is a related reference.
Kelly