Forum Discussion
Creating Relationships based on Timestamp Range
Greetings everyone, I am having an issue that is probably more of just a data design issue than a PBI issue. Either way, I cannot figure out how to proceed. Our business has lobby customers ...
Can anyone provide some guidance on this? I've been trying LOOKUPVALUE() formulas today and still can't get the result I'm looking for.
I can think of a way to do this, but if and only if your submittedDate + CustomerServiceCounter columns (combined) in that survey results table is guaranteed to be unique.
You could expand out your time range into a duplicate row for every minute within the range, and then do an inner join to only take one of those duplicate rows for each survey result you have.
You could probably do this with a bit of M.