I am looking to get all months between min and max dates for a product to display on a stacked bar chart.
if Product A is selected in the slicer it should show me Jan, Feb, Mar and April. Feb as it is blank should have status of the preceding month, in this example - Ordered.
if Product B is selected in the slicer, it should show me Jan, Feb and Mar. Feb as it is blank should have preceding status, in this example - Shipped.
This is my data and I have this set up in the attached pbix with a date table
Product Status.pbix (42.1 KB)