Yesterday and DayBefore Yesterday not changing with Date Picker

[pradeepyadav921]

Hi all,

I have created a date picker and calculating yesterday and day and before yesterday for a particular data set but as a changes the date in the date picker it's not changing yesterday and day before yesterday value. Attached the DAX which I am writing for the day before yesterday and smiliar for yesterday. what should I do so that if we change the date in date picker the value of yesterday and day before yesterday also changes?  

Thanks in Advance.

[FM-Rad10 · Accepted solution]

try this:

yesterday = CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )-1

day before yesterday  = CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )-2

[Chakravarthy]

Hi @pradeepyadav921 

Create Measures as below:

Yesterday =

VAR _MAX = MAX('Table'[Date])

VAR _MIN = DATE(YEAR(_MAX),MONTH(_MAX),DAY(_MAX)-1)

RETURN _MIN

Day_Before_Yesterday =

VAR _MAX = MAX('Table'[Date])

VAR _MIN = DATE(YEAR(_MAX),MONTH(_MAX),DAY(_MAX)-2)

RETURN _MIN

[pradeepyadav921]

It's giving 15 march as yesterday because 16 march is the last date in the dataset but I want that whatever date I select in the date picker suppose I select 13 march then yesterday and day before yesterday values changes to 12 march and 11 march

[Chakravarthy]

@pradeepyadav921 

I am able to see the below