Import excel file

[Suliman]

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.

[az38]

Hi @Suliman 

please, provide us a little bit more information about your data 🙂 maybe, example of your excel 

in common case you do not need any transformation. just import and drop columns into your visuals in report mode

[Suliman]

It is for about 20 cities and more than 20 days

[Suliman]

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. etc

[edhans · Accepted solution]

We'd really need to see sample data @Suliman - see links below.

But on the face of it, I see you need two things:

1. A date table. See my link below about creating one in Power Query.
2. 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 Forum

Creating a Dynamic Date Table in Power Query

What is Normalizing Data?

See the Normalizing an example table section of this paper