Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help with DAX-Command

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.

 

.

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi Anonymous 

    please try

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.