Daily change measure broken as there are data gaps in time series - IF statement, or SWITCH?

[BruceA02]

Hi all and good morning,

I have a simple calculation - easy to create using the "quick measure".

So I created the daily change in my value (OPINT_1). The problem is I'm using a Date Table which I link to my data. As the data is financial data (options) there are gaps for holidays and weekends, so my "simple measure" is Too simple and my output is a mess. I started playing with IF statements but failed 😞 

The question is, how do I ignore the blank values (dates) and get a consistent time series of daily change of actual values in the data table.

Thank you for any suggestions

The Date/COMEX GOLD OPINT relationship

THE OPINT DATA

My "quick measure"

WHICH RETURNS THE TABLE BELOW (for one, random Instrument)

[amitchandak · Accepted solution]

@BruceA02 , You can try Last Day Non Continuous 

example

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

or

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =calculate( max(Sales[Sales Date]), FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])))))

refer

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...