Value with bigest ID on every Month

[Anonymous]

Hey guys,

I am trying to get a single Value, for every Fund, every month. The value should be the one with the biggest ID. How would you calculate such a thing?

It should be these values:

I am ataching an example PBI file:

 https://www.dropbox.com/s/ci46thhglrmdt62/Example.pbix?dl=0

[Thejeswar · Accepted solution]

Hi @Anonymous ,

You can create a new calculated Column with the below DAX. That should give the Max IDs for a Fund and Month

max_id = MAXX(FILTER('VNT Vertės', 'VNT Vertės'[Fund] == EARLIER('VNT Vertės'[Fund]) && 'VNT Vertės'[Date] == EARLIER('VNT Vertės'[Date])), 'VNT Vertės'[ID])

below is the screenshot with the new column output

Now if we remove the ID column from the visul and use the one that we have created now. It gives the expected output

Hope this solves!!

If it is the expected, mark it as a anwer that will be helpful for others!!

[Anonymous]

Figured it out myself I just added another condition using te same logic. Thank you!! 

[Anonymous]

Thank you very much, it worked like you said, but I mislead you a little. I applied a few filters in transform data mode to make it more simple, but when I turned those filters of, your formula stopped working and I can't determine why. 

Here is the updated file:

https://www.dropbox.com/s/ci46thhglrmdt62/Example.pbix?dl=0

And also, could you explain what == stands for?