Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am new to the forums and I have looked around and not had any luck answering this question.
I will explain in a little more detail:
I have a large dataset I would like to break up by month. An example of the data would be as follows:
Date Name ID Country Region # of Sales Total Revenue
I would like to bring this data in through several different CSV files (by month) and create visuals as if it were 1 large dataset. So if i had 6 sets of data for January through June and i wanted to make a bar chart for total sales by month - would that be possible?
Please let me know if there is already a thread explaining this - if it is possible and how i would go about formatting it.
Thanks!
Solved! Go to Solution.
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
Revenue = SUM(Data[Total revenue])
Hope this helps.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |