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

PowerStone — Mon, 10 May 2021 17:50:36 GMT

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!

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

Greg_Deckler — Mon, 10 May 2021 18:10:05 GMT

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-TITHW/m-p/434008

topic Measure for start of month value to equal previous month ending value in DAX Commands and Tips

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

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