cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ortignano
Frequent Visitor

Measure to show onlv period when was shipped

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

 

Ortignano_0-1618317283573.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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"

View solution in original post

2 REPLIES 2
lbendlin
Super User III
Super User III

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"

View solution in original post

Thank you very much for your help.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors