Forum Discussion
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...
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