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.

     

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.

     

    • 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.