I know there are more than one way to solve this but I would use a data ladder - at tc18 Archana Ganeshalingam and Sasha Singh did a session on how it is done with specific examples on dates
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for responding. Since I am not using Tableau Prep, the above link would not be very useful.
I am following Option 4 in the link below and I able to get the correct numbers but now the problem that I am having is when bring a dimension from any of the data sources and put it on the filter shelf then both my measures in the view become red and it says "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"
If you have any idea about how it can be fixed please share. Thanks
you can to the same thing in tableau proper - they only use prep as a tool but create a date Scaffold - list of all date within the range you need then follow their model