DateMembersBetween - not working with "January 1"


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


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

The documentation here state it is possible:

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

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