Forum Discussion

Federica_18's avatar
Federica_18
Regular Visitor
5 years ago
Solved

Merge Queries

Hi, I have two tables of 11,246,448 rows and 24 columns. One containing the real values and the other containing the expected values. In order to create an overlaid line chart consisting in both rea...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Federica_18 ,

     

    can you show us the chart and how you put in the fields?

    How do you differentiate between real and expected values? This must be two different values.

     

    You could also have done that with 2 fact tables and the proper dimension tables.

     

    Best regards

    Denis

  • selimovd's avatar
    selimovd
    5 years ago

    Hey Federica_18 ,

     

    you could let it as two separate tables and use a date table that you connect with both:

    Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic

     

    Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.

     

    For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Federica_18 ,

 

can you show us the chart and how you put in the fields?

How do you differentiate between real and expected values? This must be two different values.

 

You could also have done that with 2 fact tables and the proper dimension tables.

 

Best regards

Denis

Federica_18's avatar
Federica_18
Regular Visitor
5 years ago

Hi selimovd , 

 

This is the table containing the real values:

 

 

I have columns containing latitude, longitude, date and time of day, temperature, humidity etc. For each coordinate I have measurements made for 31 days at all hours of the day.

The same thing for the table containing the expected values:

 

Moreover, I thought it could be useful to create a query merge and make a graphs in the following way:

x-axis: date and time of day;

y-axis: measured values (e.g. temperature)

Red line: actual temperature
Blue line: expected temperature

The problem is that when I merge queries, the load fails. Is there another way to make this chart without joining the two tables?

 

Thank you for your time

Federica

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Federica_18 ,

     

    you could let it as two separate tables and use a date table that you connect with both:

    Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic

     

    Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.

     

    For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis