Forum Discussion

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago
Solved

Absolute Value of data

Hi all, first post here :smileyhappy:   I'm trying to show some sales data but because my data comes from an invoice table the values are all negative which doesn't look nice in my report. I'm usin...
  • xenon325i's avatar
    xenon325i
    8 years ago

    Sorry I sent the wrong sample :smileyembarrassed:

     

    I will use your work-around by adding a column at source.

     

    Thank you for your help.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

xenon325i,

You can create a custom column in Query Editor of Power BI Desktop using the code below.

Number.Abs([Amount])

There is an example for your reference.


Regards,
Lydia

  • xenon325i's avatar
    xenon325i
    Regular Visitor
    8 years ago

    Thanks Lydia but I already tried that - you can't appear to add a custom column in Direct Query mode:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      xenon325i,

      Do you connect to SQL Server database? What is the data type of  the Amount column in SQL table?

      Regards,
      Lydia

      • xenon325i's avatar
        xenon325i
        Regular Visitor
        8 years ago

        Yes it's a connection to SQL and the data type is decimal number. As you can see, the ABS value is correct in the Custom column but as soon as I try to apply my changes I get the message that I must be in Import Mode.