Issues with DATESBETWEEN

I haven't checked the numbers but the reason these dates are included is because the model is using Auto date/time option, i.e. date tables are created in the background and these are included in your hierarchy.

So you can switch off Auto date/time and create your own date hierarchy.

--

I also have an opinion on the date table used in the model - it's not a date table in the true sense i.e. contains all dates over a period.  DAX date functions are really best used with  proper date tables.  The model and measures may work for you (which is great) but please be aware of the possible problems.

Hi Anonymous 

I did some change on your measure, please try this:

MA Accounts Receivable from Customers =
IF (
    MAX ( 'Date'[Date Key] ) < DATE ( 2014, 12, 31 ),
    BLANK (),
    CALCULATE (
        AVERAGEX ( BalanceSheet, [Accounts Receivable from Customers] ),
        DATESBETWEEN (
            'Date'[Date Key],
            DATE ( 2014, 12, 31 ),
            MAX ( 'Date'[Date Key] )
        )
    )
)

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.