Hi @irv45,
If you want to aggregate moths, then you should specify the Month level in the expression: [Time].[Month].DateMembersBetween
.
And expression to group month from January till June for year 2024 might look like this:
Aggregate(
[Time].[Month].DateMembersBetween('Jan 1 2024','Jun 30 2024')
)
Please see this post for a more dynamic solution:
Best,
Zane / support@eazyBI.com