Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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"
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"
Thank you very much for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |