Solved: Take only last record of Month and grouping a tabl...

h_distler · ‎03-10-2023

Hi,

I have searched around the Community but only found examples which are slightly different.

As others were saying sounds easy, but somehow I struggle.

So what am I trying to do:

I am tracking the "monthly" amount which is available on some accounts.

For this I just want to keep the last record of a month (including the current month) per group.

I have this input:

and I want this output:

I have created an excel file with the data.

download

Ahmedx · ‎03-10-2023

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhizH4e8YZ5W0xvrF?e=XjS612

View solution in original post

h_distler · ‎03-10-2023

This is great thanks a lot

CNENFRNL · ‎03-10-2023

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!