Always Show Yesterday, Today, or Tomorrow's Data
Executive: Are these values correct?
Excel-guy: yes, but you need to check the dates slicers to see what dates the report is using
Executive: Ugh. I just want to click on the report and see the latest values
If you ever had this situation before let me tell you that you're not alone on that one.I've been there before and it's time to give you some cool easy tricks on how to set up a Powerpivot report that shows you the yesterday, todays, tomorrow, next week or any type of timeframe (forecasting or that sort of scenario).