Getting two different date with one relationship

[JoseAGonzalez]

Hi everyone,

Issue: I have a report to present inventory at launch date (ICW) and sales over the next three months (Service Months). When I see the inventory and filter with Fiscal Year/Month slicer (Synchronized through report pages) it shows the correct information, but when I try to see the sales information, it shows as if all sales happened on launch date.

Already tried merging tables or using USERELATION without success.

Support needed: I need to filter by "Fiscal Month Number" and see inventory based on "ICW" but sales on "Service Month"could it be done? Ideally I would like to keep synchronized slicer for date across report pages.

Report goal:

1- Inventory of product at launch date ("ICW" column)

2- Sales over the next 3M after launch ("Service Month" column)

Data structure:

- Fiscal Calendar table --> Launch Information by product (Relation ship on Date | Launch Date (ICW)

- Launch Information by product --> Sales (Relation on Product (IRC) | Product (IRC)

Thank you very much in advance for your help.

[mussaenda]

Hi @JoseAGonzalez ,

You need to connect both of your tables to Date Table to get your requirement

[JoseAGonzalez]

Hi @mussaenda,

This would create a circular relationship, and by default I can only have one relationship active. This is why I tried USERELATIONSHIP (to select the new Date relationship) but without sucess.

[mussaenda]

hi @JoseAGonzalez,

I understand that.

And I assumed  that you will remove the relationship between the two fact tables and relate them both to the date.

[JoseAGonzalez]

Hi @mussaenda ,

I have basic information of the products on the inventory table and also particular inventory data I need when reflecting sales. By having the conection through Date I lose this relationship and results showed are not accurate.

I would try to reshape data and have 4 tables to see how it hows in the mean time.