Forum Discussion
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: This is the relation tab in the report: ...
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.
v-frfei-msft
Community Support
Community SupportHi 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]))
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?
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.