Forum Discussion
problems with tables in excell
I have an Excell table with energy consumption per date-time(15 minutes intervals)-day of the week. When trying to make visualizations in the desk top, powerBI show/reports the data not in a normal ...
nonoliem In order to sort your dates, and use time to analyze your data in a better way, you want to create a date table. If you are importing your data into Power BI, here is a really straightforward blog on how to accomplish this. At the end it explains your issue, you need to sort by a different column to force the dates to align as expected. When you have the date table created, just create a relationship between your date column in your table to the date column in the new date table. This will allow you to look at your data in multiple different ways across different time segments.