Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there. Converting from Tableau, so please be gentle!
I have two tables:-
In the ORDER table, I am wanting to return the nearest [DEPT] match based on the DEPT table.
So for Case Refs 123 and 456, it should return "A" as the [Order Date] falls between the [Date Change] dates in the DEPT table.
Cases 789 and 987, returns "B" and so forth.
I have the DEPT table sorted by [Name] then ascending [DATE CHANGE].
Many thanks for your valued advice in advance. 🙂
Solved! Go to Solution.
Hi, I am not sure how your datamodel looks like but please check the below if it suits your requirement.
It is for creating a new column.
Department CC =
MAXX (
FILTER (
Department,
Department[Date Change]
= MAXX (
FILTER (
Department,
Department[Name] = 'Order'[Name]
&& Department[Date Change] <= 'Order'[Order Date]
),
Department[Date Change]
)
),
Department[Dept]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, I am not sure how your datamodel looks like but please check the below if it suits your requirement.
It is for creating a new column.
Department CC =
MAXX (
FILTER (
Department,
Department[Date Change]
= MAXX (
FILTER (
Department,
Department[Name] = 'Order'[Name]
&& Department[Date Change] <= 'Order'[Order Date]
),
Department[Date Change]
)
),
Department[Dept]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
59 | |
21 | |
18 | |
16 | |
15 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |