Selecting Prior Date data in a table with Non Contiguous Dates

Question

Hi,&nbsp;I am used to working with&nbsp;Contiguous Dates. We have tables that contain snapshots of a point in time. The table contains the prior day close numbers and the prior month end numbers.&nbsp;&nbsp;I can get the prior month end just fine without a slicer.&nbsp;I cannot figure out how to incorporate a slicer and pull the prior month end of the selected date.&nbsp;I suspect this is simple and my issue is not knowing what DAX to use.&nbsp;&nbsp;The data is simple:&nbsp;AR_Snapshot Table&nbsp;DATES_TableEffective DateAR_Amount&nbsp;CalendarDate1/29/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10,000&nbsp;Contiguous Dates&nbsp;12/31/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000&nbsp;&nbsp;11/30/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000&nbsp;&nbsp;10/31/2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data Expected with Slicer set to 12/31/18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CurrentPrior&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000.00&nbsp;&nbsp;

v-lili6-msft · Accepted Answer

hi,&nbsp;Anonymous
You could try to use&nbsp;PREVIOUSMONTH&nbsp;Function to add a measure like this
pre amount = CALCULATE(SUM(Table1[AR_Amount]),PREVIOUSMONTH('Date'[Date]))
Best Regards,
Lin
&nbsp;

Forum Discussion

Selecting Prior Date data in a table with Non Contiguous Dates

1 Reply

Related content

What is contiguous selection?

Substitute for SAMEPERIODLASTYEAR() which will work for non contiguous selections

Function 'SAMEPERIODLASTYEAR' expects a contiguous selection Issue

Remaining Balance Depends on Prior Month

Contiguous date selection error - YTD LY

AR_Snapshot Table		DATES_Table
Effective Date	AR_Amount		CalendarDate
1/29/2019	10,000		Contiguous Dates
12/31/2018	8,000
11/30/2018	11,000
10/31/2018	7,000


Data Expected with Slicer set to 12/31/18

Current	Prior
8,000.00	11,000.00