Creating two time block (Jan - June and July - Dec) which updates

Questions & Answers
1 
Aggregate(Filter(
[Time].[Month].CurrentDateMember,
[Time].CurrentHierarchyMember.key <=6
))
2

Hi @irv45,

You got the right idea to filter month by key. You might want to adjust the calculation and specify the set of month level members, and then apply the filter criteria.

The expression to aggregate the first six months of the current year would look like this:

Aggregate(
  Filter(
    --set of month level members for current year
    Descendants([Time].[Year].CurrentDateMember,[Time].[Month]),
    --check the month number
    [Time].CurrentHierarchyMember.key <=6
  )
)

You can make a similar expression for July - December period and filter [Time].CurrentHierarchyMember.key > 6

More details on calculate members in Time dimension are described in the documentation: Calculated members in Time dimension

Kind regards,