Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community,
We have two different columns. One column for articles, one column for stocks.
The column article contains multiple entries for every week.
We need a DAX-formula with output of the first week, where the stock is under zero, or, when there is no negative stock , the count of 99.
I would appreciate your help.
.
Hi @EnTurk
You can refer to the following example
Creata a new column
Ausgabe = var _filter=MINX(FILTER('Table',[Atrikle]=EARLIER([Atrikle])&&[Bestand]<0),[Kalenderwhche])
return IF(_filter<>0,_filter,99)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @EnTurk
please try
New Column =
MINX (
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Article] ) ),
'Table'[Stock] < 0
),
'Table'[Week]
)
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |