Forum Discussion
Anonymous
2 years agoNot applicable
Yesterday filter in a table
Hello everyone, New to powerBi I'm currently working on a dashboard that draws its data from a sharepoint database. To summarize, alerts are created for certain references on specific dates. I...
christinepayton
2 years agoMost Valuable Professional
I recommend using a date table in a relationship that has a relative days numeric column. Then you can filter on relative date = "-1" to get yesterday's data. It will not include the current day in this case because "today" is 0 in relative days.