Count number of accounts with same end date

[gracechilton]

Hi,

I'm trying to find for each date in a specific range, how many accounts had their most recent billing period end on that date. I'm able to find, by account, the most recent billing period end date, and I can also see, by date, how many accounts have A billing period that ends on that date. However, I'm unable to view date by date the number of accounts that have their LATEST billing period end on that date.

If anyone has any ideas on how to help with this, that would be great.

[Greg_Deckler · Accepted solution]

Whoops, left out an ALL:

Measure 2 = 
VAR __BillingDate = MAX('Billing'[Billing Period End Date])
VAR __tmpTable = SUMMARIZE(ALL(Billing),Billing[Account ID],"__lastBillingDate",MAX([Billing Period End Date]))
RETURN
COUNTROWS(FILTER(__tmpTable,[__lastBillingDate]=__BillingDate))