cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RE Regular Visitor
Regular Visitor

calculate number of registrants this time last year

My organization hosts a yearly event and I am writing a report that shows guest registration. I am trying to write a measure that calculates how many people registered on this day last year. Any ideas? 

2 REPLIES 2
Highlighted
Super User
Super User

Re: calculate number of registrants this time last year

You need to use time intelligence https://exceleratorbi.com.au/dax-time-intelligence-beginners/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
v-huizhn-msft Super Contributor
Super Contributor

Re: calculate number of registrants this time last year

Hi @RE,

If you want to calculate how many people registered on this day last year. In your resource table, there should be the people ID and registered date. Please create measure using the formula.

count=CALCULATE(COUNT(Table[ID]),FILTER(Table,Table[registered Date]=DATE(Year(Today()),Month(Today()),Day(Today()))))


If this still don't resolve your issue, please share your sample table and list the desired result.

Best Regards,
Angelia