Forum Discussion
Post PatronGroup lines together with dates and time
Community ChampionThere's probably quite a few ways you could do this, one would be to use Power Query to Group By and add a column for Min Date, and Max Date and rename those as start and end date for the project.
Post PatronAllisonKennedy this has partly worked, however, i didn't mention that there could be multiples of the same project against different times in the year.
could you still do this?
- AllisonKennedy
paulfink In that case you may need to try something a bit more complex, find the previous date for each project and if there's a gap, then flag it as a start date, if not, check if it's an end date and flag that, then add an index or a count and then group by?
https://www.myonlinetraininghub.com/referencing-next-row-power-query
Or you could find this in DAX using variables and MAXX function. Does that make enough sense or do you need more help?