Measure to show onlv period when was shipped

[Ortignano]

Hi all,

I have a shipment table with a product ID and date of shipment and a calendar table linked with data (started from 01/01/2016 up to 2024)

If I would know the shipment for a product where the first shipment was done on 01/01/2008 my pivot show also data from 2006 and I'm not able to not show this data.

I try to add a calculated column in my shipments table 

=AND ('Calendar'[Date]>=MIN(Shipments[Ship date]) , 'Calendar'[Date]<=MIN(Shipments[Ship date])) and filter when is true but this allow me to not show only data after last shipments.

Can someone help me?

Thanks

[lbendlin · Accepted solution]

Use the date from your calendar table as the first element in the visual.  Then click on its dropdown and enable "show items with no data"

[Ortignano]

Thank you very much for your help.