Forum Discussion

vijayit43's avatar
vijayit43
Frequent Visitor
9 years ago
Solved

Opening Stock as per given input date by user

Dear All ,

             We want to create Opening Stock as per given Input date by User. how to achieve it. please suggest. for example.

ITEMNAMEDATEPHYSICALQTY
GV500-150216130-06-2016 27
GV500-150216102-07-2016 -15
GV500-150216106-07-2016 1
GV500-150216124-07-2016 1
GV500-150216125-07-2016 1
GV500-150216110-08-2016 1
GV500-150216111-08-2016 4
GV500-150216117-08-2016 1
GV500-150216128-08-2016 -13
GV500-150216115-09-2016 -4
GV500-150216122-12-2016 -1
GV500-150216106-04-2017 -3

 

if we Select date (07-07-2016) then Opening stock show as 13 how to achieve it please help.

 

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    vijayit43

     

    Hi, try with this:

     

    Assuming that you have a calendar table to your selection date. (Don't related to your table)

     

    OpeningStock =
CALCULATE (
    SUM ( Table2[QTY] ),
    FILTER ( Table2, Table2[DATEPHYSICAL] < SELECTEDVALUE ( CalendarTable[Date] ) )
)

    Regards

     

    Victor

    Lima Peru

1 Reply

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    vijayit43

     

    Hi, try with this:

     

    Assuming that you have a calendar table to your selection date. (Don't related to your table)

     

    OpeningStock =
CALCULATE (
    SUM ( Table2[QTY] ),
    FILTER ( Table2, Table2[DATEPHYSICAL] < SELECTEDVALUE ( CalendarTable[Date] ) )
)

    Regards

     

    Victor

    Lima Peru