How to get data for a measure with latest date

• javawebdeveloper

  Grasshopper

  Points: 23

  More actions

  April 18, 2017 at 1:00 pm

  #149482

  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

• javawebdeveloper

  Grasshopper

  Points: 23

  More actions

  April 24, 2017 at 2:30 pm

  #1939658

  Hi ,

  Can someone help? I think it should be lastchild of time dimension hirerarchy?

  Thanks