The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm looking to find the first date where the value of a style drops below 6,000.
Current formula is Stockout Day = Calcualte(Min(Calendar{Date}), Filter (In Stock Data , [Running] < 6000))
Running is a cumulative total that decreases each day. The current formula just returns the current day inside the table.
I was unable to paste an image here, but any help would be amazing!
Thank you,
Hi @Anonymous
filter without ALL() works in row-context
try
Current formula is Stockout Day = Calcualte(Min(Calendar[Date]), Filter (ALL(In Stock Data) , [Running] < 6000))
do not hesitate to give a kudo to useful posts and mark solutions as solution
Please use below, it should give you the required result.
Current formula is Stockout Day = Calcualte(Min(Calendar{Date}), Filter ALL((In Stock Data[Running]) , [Running] < 6000))
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |