Good evening everyone and thank you in advance for your help.
I have a table with the following Columns:
[Date]
[Ticket Number]
[Weight 1]
[Weight 2]
I need to lookup the [Weight1] that matches the following Criteria:
[Weight1] = [Weight2]
After [Weight2] [Date] && Over a Range of 30 days
Thanks
Would you expect that application of those criteria would always result in a single unique record, or could there be more than one record meeting those criteria?
Answer will guide whether to create a measure or a calculated table or table variable.
– Brian
Hi @BrianJ
Thanks for coming back so quickly.
I expect only 1 match given the range
It’s a bit difficult to provide a specific answer without seeing a PBIX with your data model, but I would suspect that something close to this should work
If it doesn’t, please provide your PBIX work in progress, and I’ll be glad to work through a specific solution.
I hope this is helpful.
Hi @hatsilva 
Good to see that you are having progress with your question.
Did the response provided by @BrianJ help you solve your query?
If not, how far did you get and what kind of help you need further?
If yes, kindly mark as solution the answer that solved your query.
Hi @hatsilva, we’ve noticed that no response has been received from you since October 20.
We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Good morning All,
Apologies in particular to @BrianJ for not getting back sooner, but I had to travel abroad on a short notice due to family matters.
I did not have the time to test the solution and will hopefully be doing so early next week with feedback to follow.
Many thanks and apologies again.
Hugo
Hello @hatsilva, a gentle follow up if you were able to test the solution provided above?
Morning All.
I can confirm the solution provided by @BrianJ is working.
Many thanks for your help.
Hugo
