Evaluation of a large matrix csv file

[Anonymous]

Hello Community

First of all, my English is unfortunately not so good, so I work with a translator.

I have a matrix csv table which is very large. I would like to process it as easy as possible with Power BI.

The table looks like this:

Date	Location1	Location2	Location3	....
20.01.2020	45	12	448	...
19.01.2020	78	111	44	...
18.01.2020	46	156	99	...
...	...	...	...	...

Currently I convert this table with a VBA, so that all values are in one row (this is how I currently know the evaluation with Power BI).

Date	Location	Value
20.01.2020	Location1	45
19.01.2020	Location1	78
....	...	...
20.01.2020	Location2	12
19.01.2020	Location2	111

But the initial tables are very large (e.g. 10 years of daily values at 500 locations) and therefore I need more than one csv for my result (with 1.048.576rows the csv is the end).

The way I am doing it now, I can easily sort the data afterwards (by region, by size ... and everything in combination with different time ranges).

But I think with Power BI you can solve this much more elegant and faster.

Unfortunately I'm still a beginner in Power BI but I'm working my way more and more into it.

I thank you in advance for the ideas how I can evaluate these tables

Renato

[JarroVGIT · Accepted solution]

Hi @Anonymous ,

I have loaded your sample data into Power BI and opened Power Query:

I then select the three 'location' columns and go to tab Modelling and hit "Unpivot Columns":

The last picture is the result. Does this help you? Power BI is definitely an elegant way of performing this task! 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

@JarroVGIT 

Thanks, it worked perfectly. I knew there was an easier way.