Forum Discussion
Time Intelligence Function is not working with Date table
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
No Replies