Timezone issues between Power Bi desktop and service

Hi all,

I am having an issue with the timezone differences from service to desktop. I have a matrix which shows sales, budgets etc..

On the desktop I have created a measure called 'IsFuture' where I refer to the date in the Date table and determine whether it is future (=1) or is not (=0). I then apply this measure as a filter on the matrix to ensure it only shows data for the dates that are not in the future ('isfuture = 0). This works on desktop - but when publishing to service it doesnt include yesterdays results because of the service using UTC time instead. 

Also, I have a card visual representing yesterdays results, I have used a relative date filter where date is in the last 1 days (not including today) but suprisingly it is showing me results from 2 days ago which doesn't make much sense. E.g. todays current date for me is 8th Feb 2021, but the relative date is picking up 6th Feb 2021 as yesterday in the desktop .pbix

How can I fix these issues, I have seen many articles about using Power Query but unsure how to put them into practice because my date table is a CALCULATED TABLE not a query...