I need to write a SSAS Calculation. I have DimTime hierarchy and one measure. DimTime hierarchy is Year-Month-Week-Date. I want that if we choose Month it should pick data of last day of month and if we choose week, it should pick data of last day of week. Please help. Need more information, please let me know