Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax formulas

i want to find count of each product not received orders after last received order date. i tried some dax formulas, but it doesn't work.   Not received orders after last received order = VAR ord...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

answer:

Measure =
VAR lasorderdate = CALCULATE(MAXX(Sheet1,Sheet1[Order date]),Sheet1[Received order]>0)
VAR after_lastorder = CALCULATE(COUNTROWS(Sheet1),Sheet1[Order date]<lasorderdate,Sheet1[Received order]=0)
return after_lastorder