Get values outside range of date slicer

[Anonymous]

Hi,

I am having an issue with my measure calculating a value that includes info from a previois week.

I have a date slicer filtered on Week Ending whereby:

Monday - first day of the week

Sunday - last day of the week

I have the following measures:

LicenseCountPreviousDay = CALCULATE([LicenseCountPerDay], PREVIOUSDAY('Date'[Date]))

LicenseCountPerDay = 
SUM('SubscriptionAnalyticsMerge'[SubscriptionAnalyticsDetail.licensecount])

Users Added= [LicenseCountPerDay] - [LicenseCountPreviousDay]

All is good until I need to get values for LicenseCountPreviousDay on the first day of the week.

This value always is blank as it filetered out by the date slicer.

I need some ideas on the best way to get the previous value.

Thanks

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you manually define date filter condition, time intelligence functions not suitable to deal with this scenario.

LicenseCountPreviousDay =
VAR currDate =
    MAX ( Date[Date] )
RETURN
    CALCULATE (
        [LicenseCountPerDay],
        FILTER ( ALL ( Table ), [Date] = currDate - 1 )
    )

Regards,

Xiaoxin Sheng