Hey guys! I'm just starting out with PowerPivot and I've hit a roadblock. I have a Date Table set up that I use to filter my data. I also have linked a table of daily exchange rates, but it is not completely filled in daily (e.g. I have rates for 5/24/14 and 5/26/14, but not 5/25/14...) I'm trying to make a calculated field so that when I slice on the complete Date Table, the most recent exchange rate to the filtered date is used to multiply another field "Amount" (e.g. - if I filter on 5/25/14, I would like the "Amount" field to be multiplied by the exchange rate from 5/24/14 since the 5/25/14 rate isn't available. If I filtered on 5/26/14, it would multiply by the 5/26/14 rate...) Can somebody please help me out or point me in the right direction? I think it will require a LASTDATE() function, but haven't been able to work it out yet and I'm starting to get frustrated. Thanks!