I'm going to post this without a workbook for now. I have a table that is pulled in through powerpivot it's pretty much a simple table with about 26 records that get put into the table in SQL then brought over in powerpivot daily. What I need to figure out how to do, if find the date minus one...