Maximum SUM of each month/year group

[aglpr]

Hi all,

It seems this calculation is should be simple and easy, but I can't figure out how to put it into DAX code

So, I have this table data, containing social media paltforms and the number of the followers on each month

And I want to put it into a graph bar for yearly comparison

What I want to achieve is sum of grouped follower number by platform from the max of month per year (which means the sum of follower number of every December month), and also includes the past calendar month of running year.

I tried to use the Maximum function on the "Followers" metric, but I forgot that it will use the maximum number from the whole year data. I have tried to use the Group By function on the power query as well with no luck.

Should I write a DAX measure or this or is that any ther way to approach this?

Thanks much!

[v-shex-msft]

Hi @aglpr ,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...