Filter on time and have the month day for day


Is there the possibility in eazybi to make a filter on the time whose selection for 2 months, will give a measurement going from the date of the day until the date of this same day for 2 months?

For instance:
I want to have the number of planned times over the next 2 months.

Today is 11/18/2022. the filter that I am looking for will have to give me the planned times for 2 months from 11/18/2022 to 01/18/2023.

Thank you for your help.

Hello @Nanangoran,

Welcome to EazyBI community!

EazyBI Time dimension allows you to create various combinations for time filtering. You might find this information useful when learning more about relative dates - Date filters

To create 2 months ago time period, you can define a new calculated member in your Time dimension. You can Aggregate several Time dimension members with a formula like this:

[Time].[Day].DateMembersBetween('2 months ago', 'today')

Let me know if this helps!

Best wishes

Elita from


Thanks for your feedback. After the test, it is rather the opposite that works well. that’s to say:
[Time].[Day].DateMembersBetween(‘today’, ‘2 months from now’)

@Nanangoran Thanks for following up! I apologize for missing the future part, however, I am glad you were able to make it work!

1 Like