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
Good day. Am new to Power BI - just getting used and watching some online training.
Here is my question.
I have two columns.
Each column has 10 data fields
I would like to subtract column A from Column B and have the results in Column C.
Can someone help me on how to do it?
Thanks
Sriram
Solved! Go to Solution.
Hi @sea_sriram
Create a calculated column
ColumnC = ([ColumnA] - [ColumnB] )
If this works please accept it as a solution and also give KUDOS.
Cheers
CheenuSing
Are you saying that each column has values in 10 rows? If the columns are numeric then @CheenuSing's formula will work if you create a new column and give it the formula he provided.
Hi @sea_sriram
Create a calculated column
ColumnC = ([ColumnA] - [ColumnB] )
If this works please accept it as a solution and also give KUDOS.
Cheers
CheenuSing
hi
Encouraged by above - if subtraction is to be done with a column say buy-sell in this example, what wud it be pls?
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |