New calculated member for half years

Questions & Answers
1

I’m looking at have a graph comparing H1 (Q1 and Q2) and H2 (Q3 and Q4). I’m struggling to understand how to set up a calculated member for this. They need to be on the same graph so that I can compare them.

Thanks,

2

Hi,

you might try something like:

Aggregate(Filter(
[Time].[Quarter].Members,
DateBetween([Time].CurrentHierarchyMember.StartDate,
'2018-01-01', '2018-06-30')))

Something similar worked for me just fine.
Cheers.

1 Like
3

Hi,

I believe @Erik already has shared one way of creating a calculated member.
Another way you could try is this code for H1

Aggregate(Filter(
[Time].[Quarter].Members,
[Time].CurrentHierarchyMember.key <=6
))

This would include all quarters from 1st to 6th (included) from all years.

Martins / eazyBI support