Get data from the previous day

[Edgar_massa]

Good morning guys

I have a little problem that is really annoying me in PowerBI.
I have a table (as shown in the attached image), where I have a measurement called "Test", (in the last column), and I want to get the "Completed Work" from the previous day, simple thing.

Att,

[amitchandak]

@Edgar_massa , You can use date table and time intelligence

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

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s