Divide values of one column by 2 and add the result to two other columns

[mafioso]

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!

[v-jiascu-msft · Accepted 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

[mafioso]

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.

[v-jiascu-msft]

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

[Floriankx]

Hello, you can create Measures

Dept A:=Sum([Revenue]*0,5

or you can create a calculated column =[Revenue]*0,5

[mafioso]

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.

[Floriankx]

Hello,

you don't have to display the revenue column.