Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Several Calculation same column DAX

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!

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Anonymous , Try a new column like

divide([Column1],[Column2])-([Column1])

View solution in original post

AilleryO
Memorable Member
Memorable Member

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Thank you both! it worked fine!

AilleryO
Memorable Member
Memorable Member

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

amitchandak
Super User
Super User

@Anonymous , Try a new column like

divide([Column1],[Column2])-([Column1])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.