Left join with condition to related table

[Anonymous]

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:

This is the relation tab in the report:

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?

[v-frfei-msft]

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]))

[Anonymous]

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 · Accepted solution]

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.