Forum Discussion

Sofinobi's avatar
Sofinobi
Helper IV
3 years ago
Solved

average quantity

hi community, i have a table that saves the operations about our products (sales and purchases), there is a column "Quantity Now" that calculate the quantity in stock (after sale or purchase). i ne...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Sofinobi , Assume you are using measure m1 as of now

    if(isblank([M1]),

    CALCULATE(AverageX(Values('Date'[Month Year]), [M1]),filter(all('Date'),'Date'[date] <=max('Date'[date]))), [M1])

amitchandak's avatar
amitchandak
Super User
3 years ago

Sofinobi , Assume you are using measure m1 as of now

if(isblank([M1]),

CALCULATE(AverageX(Values('Date'[Month Year]), [M1]),filter(all('Date'),'Date'[date] <=max('Date'[date]))), [M1])

Sofinobi's avatar
Sofinobi
Helper IV
3 years ago

thank you for your help, thats exactely what i want.

thanx