Counting Facebook Followers

[amyj33]

I have brought in Facebook data from excel.  I have total # of followers for each day

4/1/17     11,235

4/2/17     11,238

4/3/17     11,241

...

4/30/17   11,337

Typically we grow a little every day but there could be a day where we lost someone.  In my chart they want to the total followers for a month to be the number we had on the last day of the month.  They don't want an average for the month.  They want to say that for April we had 11,337 followers which is how many followers we had on the last day of the month.  How do I create a measure for this so that no matter what date range you choose, you'll always have the last day of the month = the total followers for that month?

[v-ljerr-msft · Accepted solution]

Hi @amyj33,

If I understand you correctly, you can use ENDOFMONTH function in this scenario. The formula below is for your reference. 

Measure = CALCULATE(MAX(Table1[Followers]),ENDOFMONTH(Table1[Date]))

Note: Just replace 'Table1' with your real table name.

Regards