Excluding rows from Sum of cumulative data

[errepinna]

I'm aware my title is not really clear, so I'll present an Excel example. I'm monitoring social media accounts online. One of the information I got is the total number of followers per account. I want to dispaly the monthly growth of the total followers on an histogram. My issue is that I got more rows referring to different days of the same month. I want Power Bi to ignore the other rows as they don't report the difference between each time but the total already.

So, in my example:

Total Followers in February = 600+320 = 920

Total Followers in March = 800+480=1280

Growth rate = 39,1%

However, Power BI will take the mid-month data as well.

So on an histogram it will be:

Total Followers in February = 600+320+500+250 = 1670

Total Followers in March = 800+480+400+250 =1930

Growth rate = 15,5%

I can't filter out the rows directly from data transformation because I handle MANY accounts and not every account has data collected on the same day, I need Power Bi to filter and pick the highest day per month and per account.

How can I do it?

[errepinna · Accepted solution]

Since nobody is answering, I'll explain how I found a workaround.

1. duplicate the table
2. divide the date column into three columns
3. select the month column and the user column
4. delete duplicates
5. merge the dates columns again
6. use that table

Hope someone finds it useful!

[PhilipTreacy]

Hi @errepinna 

Aren't errepinna1 and errepinna2 different accounts?  If so why are you summing their end of month totals?

Regards

Phil

[errepinna]

I'm monitoring the aggregate performances of all accounts. Connecting this with an "account table" I'm also able to apply filters.