Skip to main content
cancel
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

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

 

Best,


Chris C.

 

 

 

testdata.pbix

1 REPLY 1
amitchandak
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: https://youtu.be/bGtjoccEA38

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.