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

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.

Reply
Markljo
New Member

calculated column for dividing measure by body mass?

Hello, is there a calculation i can use to divide measure by body mass.

What would the formula be to create a new calculate based off 'L CON-EXT' / 'Body Mass'? This is to compute a 'fitness score' relative to body mass for set group of subjects (every row)

Any help is appreciated

unknown (3).png

1 ACCEPTED SOLUTION
ray_ux
Memorable Member
Memorable Member

@Markljo  can make a calculation column, something like this:

 myColumnName = 'tableName'[L CON-EXT] / 'tableName'[Body Mass] 

 

or alternatively you can shorten it by:

 

 myColumnName = [L CON-EXT] / [Body Mass]

 

so for every row, the value in myColumnName will be the value in L CON-EXT divided by the value in Body Mass

View solution in original post

2 REPLIES 2
ray_ux
Memorable Member
Memorable Member

@Markljo  can make a calculation column, something like this:

 myColumnName = 'tableName'[L CON-EXT] / 'tableName'[Body Mass] 

 

or alternatively you can shorten it by:

 

 myColumnName = [L CON-EXT] / [Body Mass]

 

so for every row, the value in myColumnName will be the value in L CON-EXT divided by the value in Body Mass

Seanan
Solution Supplier
Solution Supplier

Hi @Markljo 

You can create a new measure using the following code:

DivFunc = DIVIDE([L CON EXT],Table1[Body Mass])

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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