Trying to return data that wont repeat for minimum three days with SAMPLE function

[cmcgo3]

In my dataset, I have date table, commodity table, and sample table.  In example on 9/1/23, the commodity list returns three commodities.  How would I get PowerBI to NOT return those commodities, (asparagus, carrot, pineapple) until at least 9/4/23?  In another words, once commodity is sampled in the set of 3 on any given date, I do not want that commodity sampled again for at least three days?

Any suggestions are appreciated!!

Best,

Chris C.

testdata.pbix

[amitchandak]

@cmcgo3 , You need a very simailar solution, for 3 days. You need to consider only blank values

Power BI- Customer Purchasing in each of the last 3 months: https://youtu.be/bGtjoccEA38