Comparing data to previous date (not necessarily yesterday)

[Anonymous]

Hi,

I have two problems that i need help with please.

Problem 1 - I'd like to get the 'Swap Completed' column to say 1, when there is a change from Yes to No in the' Change' column. The equation i am using is not working and i cannot figure out why. 

Problem 2 - Sometimes the data feed into our database fails and we lose some dated information, in the example below you can see that the 29th and 30th July are missing. Can the equation be manipulated to look for the most recent previous day, as opposed to just yesterday?

Thanks, David

Swap Completed =

VAR __var1 = 'SRAN Tracker'[radioHB - Sec A Swap]

VAR __var2 = CALCULATE(VALUES('SRAN Tracker'[radioHB - Sec A Swap]), FILTER(ALL('SRAN Tracker'), 'SRAN Tracker'[Date created] = EARLIER('SRAN Tracker'[Date created]) -1 && 'SRAN Tracker'[Nominal] = EARLIER('SRAN Tracker'[Nominal])))

RETURN

IF(ISBLANK(__var2), 0, IF(__var1 = __var2, 0, 1))

[Dhairya]

Hey @Anonymous 
Can you please let me know whether "change" is your column or a measure?
If it is a column then you can use the below measure to calculate "Swap Completed"

Swap Completed = 
IF ( SELECTEDVALUE( 'SRAN Tracker'[Change] ) = "Yes", 0, 1 )

[Anonymous]

Your equation will not do what i require unfortunately, i need a change in column 'Change' i.e. from Yes to No to result in a 1 in the 'Swap Completed' column. The equation sent in my original post is a column. Also the the Nominal shown is not the only Nominal in the dataset, i'm just using this as an example.