...when i convert to table the power query...
I suggest starting by asking the person that wrote the power query code if they can help resolve the issues with event names.
I feel that you could ignore the percent and just assume that if it isn't there that it is + $
The value 2 column is not doing anything meaningful anyway since the sections are not in date/time order. Note that for row 1101 the date is 9/11 and for row 1102 the date is 9/13.
If the file was put in date/Time order then the value 2 column could be filled using a formula:
Formula:
=IF(ROW()=10001,125.73,IF(LEFT([@percentage],1)="-",INDEX([value 2],ROW())-[@value],SUM(INDEX([value 2],ROW()),[@value])))
Bookmarks