Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors