Comparing different periods at different table without date

[robertokzl]

Hello all, 

I'm trying to compare selled quant. of 2 different tables (2019 and 2020) but 2019 has all 12 month filled and 2020 just current (up to Jul. 

This tables are avaliable online at a specific website by two different links (one for 2019 and other for 2020)

Below short versio of both table i'm trying to compare

At x axis I expect to see something like below but at this figure 2019 has data until Dec. and 2020 until Jun, but 2020 are live and current month this souce will be updated with Jul. data and keep going until Dec.

Both file are avaliable in:

2019 - http://www.anfavea.com.br/docs/siteautoveiculos2019.xlsx 

2020 - http://www.anfavea.com.br/docs/siteautoveiculos2020.xlsx

table IV.

In resume: 

How can I compare in a clustered column chart accumulate until current month in 2020 without download file and edit manualy?

[Anonymous]

Dataset isn't very Power BI friendly, I'd highly recommend familiarising yourself with Power Query to tidy it up. I've created you a sample file to show you how I'd go about getting that data into a bar chart. 

https://1drv.ms/u/s!AnIEh6WhI4JogrAo8whZTRHeizC2XA?e=G84wf7 

[robertokzl]

Thats great! 
Your sample and how you work with data help me a lot. 
I will work on this sample and do some tests, but seens to be what i need.

Thanks.