Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vagelis
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]

RETURN
MAXX(
    FILTER( ALL(Table),Table[UID]=CurrentName),
        Table[Created])
1 REPLY 1

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors