Forum Discussion
paulfink
Post Patron
Post PatronGroup lines together with dates and time
hi guys, need a hand with figuring out how to fix my table. i got an excel in with thousands of lines of data detailing timings but the way its formatting is messing up my report. its struct...
paulfinkPost Patron
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
Community Champion
Community Championpaulfink 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?