Looking for a way to calculate survey results on a monthly basis where multiple surveys recorded

[vagelis]

Hi I have a lot of survey data, where people can be surveyed multiple times, even in a month, and I have to produce a report on the most recent survey from each person, I use the below as a column in the table to give me the latest date of each persons survey but where I am struggling is if someone asks me to show how the surveys performed in April eg I can filter out all months after April but I can still potentially be double counting any surveys that appeared in April as someone could have taken 10 surveys, and I'm really only concerned with the latest one in each month when giving a report on that month. Its possible that I dont even need the below but I'm not sure what the correct step would be here, thanks if you can help

Max Date =

VAR CurrentName = 'Table'[UID]

RETURN

MAXX(

    FILTER( ALL(Table),Table[UID]=CurrentName),

        Table[Created])

[amitchandak]

@vagelis , if if my blog on the same topic can help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...