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,

Do you use Power BI Desktop August version(2.61.5192.601)? I am unable to reproduce your issue here, I create a Amount column in SQL table with decimal(18,2) data type.

Regards,
Lydia

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago

Yes that is the version I am using. This is my first ever BI report so I'm probably doing something wrong because it seems I cannot do any kind of data transformation or add custom coulmns or anything at all unless I switch to import mode where it works perfectly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    xenon325i,

    You can create a calculated column instead as shown in the following screenshot.



    Or you can add a new column which has positive values in the SQL table, then import the SQL table in Power BI Desktop using DirectQuery mode.

    Regards,
    Lydia

    • xenon325i's avatar
      xenon325i
      Regular Visitor
      8 years ago

      The Calculated column almost works but for some reason the value (even though it is now positive) is slightly different from the original negative value. I'm not sure why that is but it's a start.

       

      Appreciate your help!

       

      It would be nice to know why my basic transformation doesn't work though - from what I've read on-line, it should...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        xenon325i，

        Please post the DDL script you use to create SQL table , and share sample data of your table here so that I can test.

        Regards,
        Lydia