Measure for start of month value to equal previous month ending value

[PowerStone]

Hello, 

I'm having some trouble with what should be an easy measure to make the beginning month QTY equal the previous month ending QTY.  I've tried a bunch of different ways and the QTY I'm returning is always the current month value, not the previous month. 

Here's some sample data:

Date	Year	Month Num	Month	Begin AMT	Begin AMT 2	Begin AMT 3	QTY Sold	QTY Received	QTY Issued	QTY Transfer	QTY Adjusted	End Amt
1/1/2016	2016	1	Jan	5,311	5,311	5,311	-1,382	3,936		-425	3,182	5,311
2/1/2016	2016	2	Feb	-2,353	-2,353	-2,353	-1,379			-974		-2,353
3/1/2016	2016	3	Mar	3,242	3,242	3,242	-1,558	4,800		-482	482	3,242
4/1/2016	2016	4	Apr	-2,762	-2,762	-2,762	-1,293			-605	-864	-2,762
5/1/2016	2016	5	May	17,604	17,604	17,604	-2,010	7,200		-1,207	13,621	17,604
6/1/2016	2016	6	Jun	-3,244	-3,244	-3,244	-2,020			-1,224		-3,244

The beginning QTY for February should be 5,311 and instead I'm pulling in the current month end QTY.  

Here are the 3 measures I'm using:

Begin AMT = CALCULATE([End Amount],PREVIOUSMONTH(tblCALENDAR[Date]))

Begin AMT 2 = CALCULATE([End Amount], DATEADD(tblCALENDAR[Date], -1, MONTH))

Begin AMT 3 = 

VAR DaysInterv = DATEDIFF(MIN(tblCALENDAR[Date]),MAX(tblCALENDAR[Date]),DAY)

RETURN

CALCULATE([End Amount],DATESINPERIOD(tblCALENDAR[Date],MIN(tblCALENDAR[Date]) - 1,DaysInterv,MONTH))

Any help would be greatly appreciated.  Thanks!

[Greg_Deckler]

@PowerStone You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...