venerdì 1 giugno 2012 07:57
I want to create inventory status report with power pivot. Usually I am doing with excel formula's.
I already have inventory transaction with power pivot, you can see table at below.
And I want to added Beginning Inventory and also SSR (I can do that for SSR with DAX).
FYI that there is no stock data at powerpivot table/database. TO get stock on hand, I calculated from Reception and other inventory transaction.
Can you help me ?
Tutte le risposte
mercoledì 6 giugno 2012 07:28
Do you want to do something similar to this?
Stock End Of Period :=
CALCULATE( SUM( [Units Balance] ), DATESBETWEEN( BLANK(), LASTDATE( Transactions[Movement Date] ) )
Stock Beginning Of Period :=
CALCULATE( SUM( [Units Balance] ), DATESBETWEEN( BLANK(), ADDDATE( FIRSTDATE( Transactions[Movement Date] ), -1, DAY ) )
Marco Russo http://ssasworkshop.com http://www.sqlbi.com http://sqlblog.com/blogs/marco_russo
giovedì 7 giugno 2012 11:08
What do you mean of unit balance ? is it unit of first of stock ?
because I don't have stock calculation column
I already tried and error with the function
- Modificato Henry Winata giovedì 7 giugno 2012 11:28