Forum Discussion
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...
Sorry I sent the wrong sample :smileyembarrassed:
I will use your work-around by adding a column at source.
Thank you for your help.
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.
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