Forum Discussion
cmcgo3
Helper II
Helper IITrying 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.
1 Reply
- amitchandak
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
