Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |