Variable only give current month number

[12Bowers12]

Good afternoon, everyone,

I have two variables to define the latest date.

For Var_1, there is one date (03/31/2019) in DateIndx[AS_OF_DATE].

VAR_1 LatestDate = MAX(DateIndex[AS_OF_DATE])

VAR_2 LatestDate = DATE(2019,3,31)

The following measure works by using either one variable. But when I add Month as a context, the measure with Var_2 gives the each month amount.  If changes to Var_1, the measure only gives March amount.

Any ideas?

Thank you.

Dennis

Measure WP =

VAR LatestDate = DATE(2019,3,31)

    //MAX(DateIndex[AS_OF_DATE])

RETURN

    CALCULATE (

        SUM ( CoverageFile[NET_PREMIUM] ),

        DateDimension[DateKey] <= LatestDate,

    )

[parry2k]

@12Bowers12 to get your answer quickly, please read ths post https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490