Use first date in date slicer for measure calc

[vwiles84]

Hello. I am trying to create an inventory consumption report that shows beginning inventory total, consume/adjusted amount and ending inventory amount. I have the ending inventory measure and the consumed/adjusted measure working but i am not quite getting the beginning amount. I have a date sliced added to the report so what i need to figure out is how to write the beginning inventory measure that sums the inventory up to the first date in the date slicer.  What is the best way to write the DAX? 

I have tried this: but it gives me (blank) or the ending balance, not beginning:

Beginning Balance =

var LastInventoryDate = CALCULATE(LASTDATE('TABLE'[Posting Date]), ALL('TABLE$Item Ledger Entry'))

return

IF(SELECTEDVALUE('Date'[Date]) > LastInventoryDate, BLANK(),

CALCULATE(SUM('TABLE$Item Ledger Entry'[Quantity]), FILTER(ALLSELECTED('Date'), 'Date'[Date] <= MAX('Date'[Date])))) 

I have also tried this: 

Beginning Balance = CALCULATE(SUM('TABLE$Item Ledger Entry'[Quantity]), FILTER(ALL('Date'[Date]), 'Date'[Date] >= MAX('Date'[Date])))

but it does not work. 

Any help would be greatly appreciated. 

[amitchandak]

@vwiles84 ,Can you share sample data and sample output.

[vwiles84]

I actually got the calculation to work with this: 

CALCULATE(SUM('TABLE'[Quantity]), FILTER(ALL('Date'), 'Date'[Date] < MINX('Date', 'Date'[Date])))