Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
I need to calculate a colum (row by row) with a certain amount for my report.
In excell I would type:
+(1*(Column1/Column2)-(Column1)
Column1 Is an amount and Column2 a percentage.
How do I do this in Power BI, and will it be a measure or a column?
Than you!
Solved! Go to Solution.
@Anonymous , Try a new column like
divide([Column1],[Column2])-([Column1])
Hi,
if your calculation is line by line, it should be a calculated column and your formula should be like :
Name of Column = (1*([NameColumn1]/[NameColumn2])-[NameColumn1]
or
Name of Column = (1*DIVIDE([NameColumn1],[NameColumn2])-[NameColumn1]
In Power BI you use the name of your columns not their address (B12).
You should be help by predictive keyboard.
Tell us if it worked
Thank you both! it worked fine!
Hi,
if your calculation is line by line, it should be a calculated column and your formula should be like :
Name of Column = (1*([NameColumn1]/[NameColumn2])-[NameColumn1]
or
Name of Column = (1*DIVIDE([NameColumn1],[NameColumn2])-[NameColumn1]
In Power BI you use the name of your columns not their address (B12).
You should be help by predictive keyboard.
Tell us if it worked
@Anonymous , Try a new column like
divide([Column1],[Column2])-([Column1])
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |