Mithun,

You can blend on Month year filed for all the data sources. After you drag this field on the filter pane, in the drop-down select 'All using related Datasources'.

Can you attach a sample workbook?

Hey Mithun,

You can mask the sensitive data and create some just data using excel file and post with .twbx file.

Without knowing  proper issues, its very difficult to answer for your questions.

Check Video how you can create with sample data using files.

Anonymize your Tableau Package Data for Sharing

Thanks

Also,

Have you tried custom Edit Relationship using Data tab in the report. try to connect all datasheets using Date(As you mention) and try connecting once again.

1. Select Data > Edit Relationships.
2. In the Relationships dialog box, verify that the primary data source is selected from the Primary data source drop-down list. In this example, the Sample - Superstore data source is selected.
3. Select the secondary data source in the Secondary data source pane, select Custom in the relationships list, and then click the Addbutton. In this example, the Sales Plan data source is selected.
4. In the Add/Edit Field Mapping dialog box, do the following:
   1. Select a field from the primary data source.
   2. Select a field from the secondary data source to establish the linking field or the relationship between the data sources even though the fields do not have the same name.
   3. Click OK.In this example, a relationship between Segment field in the Superstore – Sample data source is selected and Customer Segment field in the Sales Plan data source is selected. You can map these two fields to create a relationship even though they don't have the same name.
5. (Optional) Continue to add and remove as many relationships as necessary and then click OK.The related fields are shown in the secondary data source as potential linking fields.

Blend Your Data