topic Need help with DAX-Command in DAX Commands and Tips

Need help with DAX-Command

Anonymous — Mon, 30 Jan 2023 14:11:38 GMT

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.

tamerj1 — Mon, 30 Jan 2023 14:36:30 GMT

Hi Anonymous

please try

New Column =
MINX (
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Article] ) ),
'Table'[Stock] < 0
),
'Table'[Week]
)

Anonymous — Wed, 01 Feb 2023 06:24:25 GMT

Hi Anonymous

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.