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
You could use an Append query but the easiest thing to do would be to put all the CSV files in a folder and use a Folder query.