Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
Hi @Anonymous ,
bridge = union(values(bookings[column]),values(Slot[column]))
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |