I have literally been trying to figure this out for the past 4 hours. I have tried using variables, Previousday, intervals, etc.
No matter what I do I literally can not seem to select a single cell from yesterday's date. I need to create a measure beacuse I have to use that number to do further calculations. It should not be this difficult =[
I have a table that already aggregates total users and updates daily. Just need a measure to select this value. I have a date table.
Have you tried using DATEDIFF?
Not PBI infront of me but you should be able to work it out with the use of NOW() and your date - 1.
The second skinnier image is the table with the values I am trying to pull from yesterday. Imagine runstatus is "ActiveCount" as that is the actual column I am trying to grab since it automatically aggregates daily.