Slicer date addition in Power BI to reflect from minimum date till yesterday's date

 Hi All,

When you have a slicer in your dashboard that gets data from a calendar table saved in SSAS tabular model and then your requirement changes that the slicer should display max date as Yesterday's date

Apply the below DAX formula to your calendar and Bingo, issue is fixed !

=CALENDAR ("1/1/2015",TODAY() - 1)