Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 haveConnect.PNG

 

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

 

Error.PNG

 

can please somebody help me ? THANKS !

1 REPLY 1
Shaurya
Memorable Member
Memorable Member

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors