Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I created a P&L report, but I have little problems with prefixes. I have a table like this one:
I have a running total amount column by the main groups as you seen, 1. Main Group is 80 and 2. Main Group total is 80 -50 +20 = 50.
The only thing I want to change is that if the amount is negative (these are the costs), I'd like to see these amount by positive prefix, but in the Running Total I'd like to see the calculation like in the example,:
Main Group 1.
Do you have any idea how can I solve this problem?
Thank you in advance for your help!
Mate
Not sure I'm 100% clear on this but you should be able to create your measure such that you return 20 instead of -20 by using a simple SWITCH or IF statement.
Dear @Greg_Deckler
Thanks for your reply!
I know I can change the numbers to positive, but than in my example, in the calculation maybe in the 1. Main Group it will be 120 instead of 80, because there will be 100 & 20 (20 is the cost but positive) but in the measure itt will add to the 100 won't it? Thats my huge question! I want that 100 - 20 = 80, but as the table shows +20 instead of -20 -> (+)100 & (+)20 (but this is the cost)= 80
Any idea?
Thank you very much!!
Mate
hi, @Anonymous
Could you please share your sample pbix file, We need specific data structures, You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Dear @v-lili6-msft,
I've this table with the measure:
In this running total I'd like to see everíthing with + prefix, also when it's a cost (where now is -), but the running totals should be the same, so it should be sales - costs, but cost also with + prefix.
Thank you in advance!
I was thinking that you would create a second measure for display purposes. So, use your original measure in your running total but create another measure for display purposes that returns positive instead of negative. That was the idea. But, not sure if it will work as I am not 100% on your setup.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |