year over year

Hello Team, 

I've been trying to find a solution to create a YoY calculation, I know is doable when you work with imported data, however, I am using a live connection or direct-query. Have anyone been able to accomplish this with direct-query.

thanks in advance