Forum Discussion
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 th...
Hi Anonymous
please try
New Column =
MINX (
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Article] ) ),
'Table'[Stock] < 0
),
'Table'[Week]
)