Hey,
I've been trying to resolve this issue for long - and its resolution makes the difference between a smooth reporting and a tough one.

I created a bunch of measures and two chronologies. I'd like to calculate these measures for different timelines.
If I create two columns in PowerPivot : "if( and( date >= firstdate(...) ; "date <= lastdate(...) ; "Timeline1; Blank() )" [and the same for date2] and put them as column filters in a pivot table, I get the usual :

(one below the other)
I am unable to create a single column that takes either the value 'Time range 1' and 'Time range 2'... and even if I could, I guess I would have issues if the datas were mixed (eg. timeline 1 is June and timeline 2 is YtD June, June would appear either as timeline1 or timeline2, but not as both).
I guess this is a pretty standard issue but never managed to resolve it. Could you please me indicate the smoothest way to resolve this ?
Best.
I've been trying to resolve this issue for long - and its resolution makes the difference between a smooth reporting and a tough one.

I created a bunch of measures and two chronologies. I'd like to calculate these measures for different timelines.
If I create two columns in PowerPivot : "if( and( date >= firstdate(...) ; "date <= lastdate(...) ; "Timeline1; Blank() )" [and the same for date2] and put them as column filters in a pivot table, I get the usual :

(one below the other)
I am unable to create a single column that takes either the value 'Time range 1' and 'Time range 2'... and even if I could, I guess I would have issues if the datas were mixed (eg. timeline 1 is June and timeline 2 is YtD June, June would appear either as timeline1 or timeline2, but not as both).
I guess this is a pretty standard issue but never managed to resolve it. Could you please me indicate the smoothest way to resolve this ?
Best.