Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
77
Views
Topic starter
hi Team, I am new to Power Q, i had some assistance with creating a data model. However, i do not know how to switch around the negative sign in power Q to get the net profit as a positive number and loss as a negative sign, could you please assist? attached the screenshot
Posted : 02/11/2023 4:12 am
The screenshot doesn't show any amount column(s) but let's assume you have one where the sign follows standard accounting principles.
In the PQ editor select that column and on the Transform tab choose the 'Standard' icon in the Numbers column group. Select 'Multiply ' and enter -1 in the next dialogue box and OK.
Now, you have reversed the sign for all amounts in the column.
Come back here if you need more help.
Posted : 02/11/2023 6:57 am
