Forum Discussion

Tan_LC's avatar
Tan_LC
Icon for Helper II rankHelper II
4 years ago
Solved

Calculate Daily Balance Qty

Hi, in table below, in order to get the Daily Balance (kg), the calculation should be Stock Available (kg) deduct the Usage. If the Stock Available (kg) is blank, then it should use the previous day...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Tan_LC , Sunch calculation should always done cumulative manner

 

example measure

Inventory / OnHand
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date'))   - CALCULATE(SUM(Table[usage]),filter(date,date[date] <=maxx(date,date[date])))

Tan_LC's avatar
Tan_LC
Icon for Helper II rankHelper II
4 years ago

Dear Sir,

 

Thanks on the feedback. However, error message pop up as below.

 

 

Besides, I've further make clear on my desired outcome value as below using excel. Hope you can assist.

Thanks.

 

 

Regards,

TanLC

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Share the table in a format that can be pasted in an MS Excel file.