How to pull out dynamically values from a day and previous day from table simultaneously

Hello,
I need assistance for this.
I created a dashboard to track power and energy Consumption with daily, weekly and yearly summary. However i have one challenge to achieve my final result as shown below which i need your assistance;

I can select from a year, month and day in that month to display the values of parameters for that selection;

My major problem is this;

I want when i select any day in a particular month and year, example in the attached, I selected

Year: 2018

Month: May

Day: 26

I want it to be able to display the value for Day =25 and Day =26 in separate columns Dynamically so that I can compute %Change day-on-day

Unfortunately, I couldn't write out the formulae to make it pull out the previous day=25 values at the same time.

Kindly help for my project work at office



See attached Image