How cann i connect multiple Tables correctly ?

[Anonymous]

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 !

[Shaurya]

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