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.
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])
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |