DateMembersBetween - not working with "January 1"

Questions & Answers
1

Hi,

I need a measure to filter from the start of the year until now.

image

But when I try ‘January 1’ it does not work… and I don’t know why !

The documentation here state it is possible:
https://docs.eazybi.com/eazybi/analyze-and-visualize/date-filters

So, do you have any idea that will explain why, with this calculated measure, I have no result in my graph (empty graph).

2

Hi @cdemez

DateMembersBetween function requires an exact date as the start of the range and an exact date as the end of the range.

The dynamic dates such as January 5 won’t fit for the DateMembersBetween function intervals as any year can have January 5 as a date.

Martins / eazyBI

1 Like