Forum Discussion
Solved
Merge tables based upon Start and End dates
I have an Account table linked to a Sales Rep. thatble that has effective dates of Start and End. I wnat to merge to it information from my orders table that has a single Order Date that must fall in between the Start and End of the Account/Sales Rep table. How do I do this?
Key:
AccountTable.AccntID=OrderTable.AccntID
AccountTable.Star<=OrderTable.OrdDate
AccountTable.End>=OrderTable.OrdDate
Take a look at the following article. I hope this helps.
1 Reply
PowerBIGuyResponsive Resident
Take a look at the following article. I hope this helps.