Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

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

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!!



Chris C.





Super User
Super User

@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:

Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.