Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How cann i connect multiple Tables correctly ?

Hey,

I have 3 different values in 3 different tables. I want to connects them, so that i can show the value in a line chart with each of the three volumes for the duration i have

 

everytime i want to conect them or start an autodetect, so engine doesnt find anything or i get this errorcode :

 

 

can please somebody help me ? THANKS !

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Shaurya's avatar
    Shaurya
    Memorable Member
    3 years ago

    Hi Anonymous,

     

    Create measures to calculate the sum of values for all three tables differently.

     

    Like Sum_1 = SUM('Table1'[Values])

    Sum_2 = SUM('Table2'[Values])

    Sum_3 = SUM('Table3'[Values])

     

    Add them all in a final measure Total=[Sum_1]+[Sum_2]+[Sum_3]

     

    Plot this measure in the visuals with the date and make sure that all the tables are joined individually to the Date Table.

     

    Mark this post as a solution if that works for you!
    Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI