Hi All, Just started using Power BI, and stumbled onto this accounting issue with the data. I have one column "Cost" and it can have negative values, which i dont not want to display, as it affects my charts and all. For each negative value, there will be a corresponding positive value of the exact same number (example below). This is due to my company being charged an amount, and then subsequently receiving a rebate of the full amount. But this will log as 2 rows in my database. I have tried to use Excel "duplicate value", but it ended up removing all other (positive values) with the same numbers, thus reducing my data. Not sure if there is any way i can resolve this in the Power Query Editor? Or by another other method? Cheers! Regards,Kent

There are two type conversions in my code. One is changing the type of cost from text to currency as when you manuall enter data by default is text typed. This is to allow numeric functions to be applied later such as sum average etc. The second transformations is inside the custom function.Number.Abs() requires that you enter a numeric type for it to work, so to ensure that it is a numeric type going in I have wrapped the column in Number.From() which converts to a numeric type. I do not think either of these steps should cause an error however you should ensure that the cost column is in either currency or decimal type just to be sure.

Positive & Negative duplicate values | Microsoft Fabric Community

Forum Discussion

Related content

Negative to Positive or Positive to Negative

IF Negative value

Duplicate ranking

Convert positive values to negative

Positive and negative filter