I need the Due dates corresponding to that range of invoice dates (Refer 'Start date' and 'End date' of invoices)..
So for example, for invoice BANK1712001 the actual Due date would be 5th Feb (not 5th Jan) as the invoice date (6th Dec) falls within range 22nd Nov to 22nd Dec so corresponding due date would be 5th Feb.
Hope that clarifies.
Thanks for the splits
I think that helps when there is a single datasource.
However, when I try using the same formula between 2 different datasources, I am having some issues. Some tableau experts feel that may be an issue with data blending.
I am therefore trying to blend the data using a SQL. Hopefully that should solve it along with the solution you provided!
Thanks for your help
Welcome. If that helped, could you please mark the answer as helpful or correct.