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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PbiCeo
Helper II
Helper II

How to get data from a table without any relationship

Hello everyone,

 

I have two tables without any relationship.
Table1:

CtTime
10
210
320
430

 

Table2:

Col1 Col2
Name A
TID 4643248_ABC
Speed 100km/h
Model BC

 

I want to get data from TID  4643248_ABC of table2 and join it to table1 like below:

 

Ct TID Time
1 4643248_ABC 0
2 4643248_ABC 10
3 4643248_ABC 20
4 4643248_ABC 30

 

What formula should I use for this?
Thanks in advance,
Vladi

1 REPLY 1
rfigtree
Resolver III
Resolver III

hi, is this sort of what you want (minus the column layout) - DAX

rfigtree_0-1613713367959.png

or power query

rfigtree_1-1613713544639.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors