Forum Discussion
Edgar_massa
Helper II
Helper IIGet data from the previous day
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,
1 Reply
- amitchandak
Super User
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-5c3243d1f9Time 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
