Forum Discussion
Using Multiple Identical Data Sets for the Same Visuals
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,
Try this
- Append data from the multiple CSV files
- Create a Calendar Table and build a relationship from the Date column of the appended dataset to the Date column of the Calendar Table
- In the Calendar Table, write calculated column formulas to extract Year and Month: Year = year(calendar[Date]), Month Name = FORMAT(Calendar[Date],"mmmm") and Month Number = MONTH(Calendar[Date])
- Click on any one cell in the Month Name column and then go to Sort by column > Month Number
- To your visual, drag Year and Month from the Calendar Table.
- Write this measure
Revenue = SUM(Data[Total revenue])
Hope this helps.