Forum Discussion
Calculate data within a grouping
Hey, guys! I've been trying to find a solution to my problem for months. I have a history of grades assigned by different users (NPS Survey) and I would like to measure the evolution of these grade...
Hi,
Probably not the most efficent solution but you could take your data table and get the date with the penultimate dates then use this to get the grade?
= Table.Group(#"Changed Type", {"Email", "Name"}, {{"PenultimateGrade", each List.Sort([Date],Order.Ascending){1}, type nullable date}})
From this
To this
It'll take a bit of work after that to merge back in etc but should be a good jump off point for you.
Thanks,