Forum Discussion
Solved
Import excel file
I have a table in excel, that I need to import into my data model i Power BI. I need to be able to slice and dice the dates (day, week, month, year). But I am not sure how to transform this data best.
We'd really need to see sample data Suliman - see links below.
But on the face of it, I see you need two things:
- A date table. See my link below about creating one in Power Query.
- When you bring the data in, You'll want to select all but the date columns, and on the Transform tab, select "Unpivot Other Columns" and normalize the data. See links below on that too.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumCreating a Dynamic Date Table in Power Query
What is Normalizing Data?
4 Replies
- Thank you for your reply ..
My data is daily covid-19 cases in some cities .. the title of columns are dates : for example :
City name 3/3/20. 4/3/20.
London. 4. 4. etcWe'd really need to see sample data Suliman - see links below.
But on the face of it, I see you need two things:
- A date table. See my link below about creating one in Power Query.
- When you bring the data in, You'll want to select all but the date columns, and on the Transform tab, select "Unpivot Other Columns" and normalize the data. See links below on that too.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumCreating a Dynamic Date Table in Power Query
What is Normalizing Data?
- It is for about 20 cities and more than 20 days
