Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

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]

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors