Forum Discussion
DAX and Time Windows
Hi PBCIT
Have you considered CONCATENATEX( )
It would help if you share some sample data and the expected result
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
I'm not understanding where this would help. I had another thought. I connected the customer ID in the time windows table to the customer table I have and the customer table is connected by customer ID to the delivery table. Do you know of a way where, if the account ID in the delivery table matches the account ID in the Time windows table, it would take the arrival time and find the one that is closest to the arrival time to compare it against? Previously, what I had done was I created a column where it concatenated the customer ID and the date. Then I created a column that flagged if I had multiples for a day. Then if the sum of the amount of times a delivery was out of the window was <=1, then I replaced it with a 0 because we did actually deliver within a time window and I don't want it to count as having not made it in the time window. This solution works but I just keep thinking there has got to be a more elegant way to go about this, ya know?