Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all 🙂 New user to Power BI so trying to get my head around it.
My aim is to get power bi to look up look through the data I have in column 2 - and replace all negative figures with positive. Any advice would be greatly appreicated!
My data looks something like this:
Acct Type | $ |
Fees paid | 10 |
Pens | -20 |
Staples | -5 |
Refunded items | 50 |
paper | -10 |
Solved! Go to Solution.
Hello @PowerNewbie98 ,
you go into Power query and click on the column you need to fix the signs and then under transform => scientific = > Absolute value
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
In DAX you can use the formula ABS (https://learn.microsoft.com/en-us/dax/abs-function-dax)
Hello @PowerNewbie98 ,
you go into Power query and click on the column you need to fix the signs and then under transform => scientific = > Absolute value
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |