Forum Discussion

Andvil's avatar
Andvil
Icon for Helper V rankHelper V
6 years ago
Solved

Filters or connections Issue

Hello, Im trying to do a dynamic market share report with sales from 2018, 2019 and 2020.  I have the information separated between the three years and I have uploaded each year individually to Powe...
Need Help
Andvil's avatar
Andvil
Icon for Helper V rankHelper V
6 years ago

Hello MFelix,

 

First of all, thank you for your answer and help.

 

I have realized that having the information in different tables is not the best option. I am not the manager of the data and the original data is extremely big and it is updated monthly.  The user that manages the data created a connection to SQL and sends it to me in different tables. Due to the size of the information, it is impossible to have it in a folder as you are suggesting.

 

Do you know another solution considering this conditions? As I mentioned at the description of the problem, i was considering appending the tables but I do not know if that would be the best solution.

 

I have checked the example you provide and that is exactly what I need. Thank you in advance for your comments.

 

Best,

 

Jose L

 

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Andvil ,

 

If that is not an option you can make the merge the tables on the query editor and then only make the upload of the final table.

I will prepare a sample file and send it to you with the explanation.

  • Andvil's avatar
    Andvil
    Icon for Helper V rankHelper V
    6 years ago

    Hi MFelix,

     

    Thank you very much for your time and willingness to help. 

     

    Have a great day,

     

    Jose L