Forum Discussion

amyj33's avatar
amyj33
Frequent Visitor
9 years ago
Solved

Counting Facebook Followers

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 ev...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi amyj33,

     

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

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

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

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi amyj33,

 

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

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

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

 

Regards