Thanks for that, I used your example and

Thanks for that, I used your example and it worked fine. However there is a solution more straightforward and after implementing it this example will do the same as your end result. TotalYTD(Sum([SalesAmount]), 'DimDate'[FullDateAlternateKey] To achieve this you should have: a: a separate time dimension table b: join the fact and dimension table with a date or datetime field. Processing time will also be much shorter. I red this on the blog of Kasper de Jonge (6 golden rules). Greetz, Frits www.newfrontiers.com