Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys, good day to all. I have a problem on the column. I tried to formulate it using Dax Formulas, but it cannot round off to thousand, and the ending is that it shows -0.2M but not -152.2K.
The formula I use is this. My question is How to change the the value -0.2m to 152.2K? It is a big help, guys, if you give any tips on my problem. Thank you all!
Solved! Go to Solution.
Hi @JohnCarl45
Just add the conditions for formatting negative numbers.
For example :
you can modify it as you need to be a part of your formula.
Link to a sample
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @JohnCarl45 :
This is the basic formula, I didn't understand what did you try to do with tens of millions so just modified it in the same logic.
The linked file has also been updated: Link to a sample
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @JohnCarl45
Just add the conditions for formatting negative numbers.
For example :
you can modify it as you need to be a part of your formula.
Link to a sample
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@Ritaf1983 Hi, Good day. Can you show me how to apply that to my formula or add it up? Thank you.
Yes. share your PBIX or at least a code on format that i can edit ( not screenshot)
Sure The Code of the dax formula that i used
Net Income Column |
-477,761.5 |
-1,180,021,.6 |
-739,495.6 |
-912,979.6 |
-152,167.2 |
450,036.6 |
That's the column of the table on the code i only used on column, but the other side is that column is filter by categories, but in the total of that whole column is up to million, that's why they have ten millions and millions on my formula, but the point is those negative numbers i can't transform them into thousands that's why
Hi @JohnCarl45 :
This is the basic formula, I didn't understand what did you try to do with tens of millions so just modified it in the same logic.
The linked file has also been updated: Link to a sample
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I figured it out, ma'am. Thank you so much for the help!
Glad to help 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |