Forum Discussion
automatically yesterday selection
i have data field .. i drag that field in dropdown box .. so i want automtically selection on yesterday dates means if today is march 5, 2020 .. then i want march 4, 2020 selection when ever i op...
In case you want only one measure do it like
Yesterday = CALCULATE(SUM(Sales[Sales Amount]),'Date'[Date] =Today()-1)
For everything, use relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Appreciate your Kudos.