Time Intelligence Function is not working with Date table

Anonymous — Mon, 22 Feb 2021 09:06:15 GMT

I have a date table in my dataset. It is marked as date table.
I need to calculate last year count. I uses SAMEPERIODLASTYEAR() function. ALso tried with other time intelligence functions also. But it is not given the last year count.

The following are the two measures that I have used in two different ways:

last_year_member_count = CALCULATE(COUNT('All Members'[Full Name]) - CALCULATE(COUNT('All Members'[Full Name]), 'All Members'[Member Status New] = "D"), FILTER('All Members', SAMEPERIODLASTYEAR('Date'[Date])))

last_year_member_count =

var member_count = CALCULATE(COUNT('All Members'[Full Name]), SAMEPERIODLASTYEAR('Date'[Date]))

var member_is_D = CALCULATE(COUNT('All Members'[Full Name]), 'All Members'[Member Status New] = "D", SAMEPERIODLASTYEAR('Date'[Date]))

var member_not_D = member_count - member_is_D

return member_not_D

topic Time Intelligence Function is not working with Date table in Custom Visuals Development Discussion

Time Intelligence Function is not working with Date table