Get data from the previous day

Edgar_massa — Fri, 24 Feb 2023 12:53:01 GMT

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,

Re: Get data from the previous day

amitchandak — Fri, 24 Feb 2023 15:18:35 GMT

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-5c3243d1f9

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

topic Get data from the previous day in DAX Commands and Tips

Get data from the previous day

Re: Get data from the previous day