Editing filtered data in Power Query Editor then viewing entire Query

[aishak12]

I'm having issues fixing my dataset, I need to get rid of negative numbers. So I filtered "OT Hours2" for values Less than 0.

Now I can fix these values by replacing numbers in another field "TotalHrs TS" when OT Hours2 is less than 0. However after fixing the data, I then lost all the positive numbers in OT Hours2, is there anyway after editing my filtered to data to view my entire query instead of only filtered data.

[Anonymous · Accepted solution]

Hi @aishak12 ,

How about create a column.

if [OT Hours2]<0 then [TotalHrs TS] else [OT Hours2]

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You said you wanted to get rid of the negative numbers but it looks like you filtered to keep only negative numbers.  Can you clarify or provide example data and desired output?

Regards,

Pat

[aishak12]

So I'm filtering for negative values so I can edit and fix them to positive. After fixing the numbers I'm left with what was originally the negative values only.

Essentially I'm asking after filtering the data, can I apply those changes to my original Query to view my entire dataset? 

[mahoneypat]

Do you want to just take the absolute value of that column?  You can click on that column in query editor, on on the Transform tab pull down the Scientific button and choose Absolute Value.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat