Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am pretty new in Power BI and have tried to fix my problem for several hours but I have no idea how to solve it.
I have the given table:
Revenue | Dept A | Dept B |
5,000 | 50% | 50% |
35,200,000 | 50% | 50% |
100 | 50% | 50% |
As I mentioned above, I want to divide the values of the Revenue column and want to split it 50/50.
Is it somehow possible to do that?
Thanks in advance!
Solved! Go to Solution.
Hi @mafioso,
Seems you want a new table. Try out this formula as a new table please.
New Table = SELECTCOLUMNS ( 'Table1', "Dept A", [Dept A] * [Revenue], "Dept B", [Dept B] * [Revenue], "Revenue", 0 )
Best Regards,
Dale
Hi @mafioso,
Seems you want a new table. Try out this formula as a new table please.
New Table = SELECTCOLUMNS ( 'Table1', "Dept A", [Dept A] * [Revenue], "Dept B", [Dept B] * [Revenue], "Revenue", 0 )
Best Regards,
Dale
Many thanks Dale!
One more question, is it possible to put Dept A and Dept B in the same column? Exactly the same you posted but in 1 col and with the appropriate names.
Hi @mafioso,
Can you post the expected result? They could be as follows.
1. The two columns are the same. So only one column will be kept.
Dept Revenue
2500 0
17600000 0
50 0
2. Unpivot these two columns. This could be complicated.
Dept Value Revenue
Dept A 2500 0
Dept A 17600000 0
Dept A 50 0
Dept B 2500 0
Dept B 17600000 0
Dept B 50 0
Which one do you expect?
Best Regards,
Dale
Hello, you can create Measures
Dept A:=Sum([Revenue]*0,5
or you can create a calculated column =[Revenue]*0,5
Ok, but if the Revenue column gets divided, the Revenue column itself must have 0. How can I fix that? So if there are 100 than i put 50 to Dept A and 50 to Dept B and nothing remains in the Revenue col.
Hello,
you don't have to display the revenue column.