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
Anonymous
Not applicable

Left join with condition to related table

Hi all

 

Im currently replacing a report which was built with a SQL query.

I got everything to work (many wheres and conditions) expect one thing:

1.PNG

This is the relation tab in the report:

2.PNG

 

Either i need to set a condition while joining, or creating a column in Orderlines to compare the From/Till dates to the ones in SlotAssignments.

 

I tried using a measure wiht using MAX(), but this didnt work. DAX' Related function is also not possible as its not the correct relation.

 

Any ideas?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Found another way to achieve my goal.

I joined the tables inside "Edit querys" and setup my rules there.

Not as nice as a DAX solution but it works.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please create a bridge table using Union function between bookings and sloa, Then related tables based on the bridge table.
 
bridge = union(values(bookings[column]),values(Slot[column]))
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

HI @v-frfei-msft 

 

I didnt get this to work. If i union these two tables, via column "Slots_ID", i just get all the slot_Id's.

What i really need is the From and Till column from table Sloa PER orderlines_ID (in table bookings or directly in table orderlines).

 

Is this also possible?

Anonymous
Not applicable

Found another way to achieve my goal.

I joined the tables inside "Edit querys" and setup my rules there.

Not as nice as a DAX solution but it works.

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.