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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SelflearningBi
Helper III
Helper III

how do i add 20% to a column of numbers in each row

Model NamePrice 
A10
B20
C30
D40 


1. how do i add 20% to price column(for each row)
2. how do i add 20% to total price 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SelflearningBi ,

 

New column = [Price]*1.2

 

Create a measure that will give 20% ast row level and 20 % at gt level

 

Sumx(Table,[Price]*1.2)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@SelflearningBi ,

 

New column = [Price]*1.2

 

Create a measure that will give 20% ast row level and 20 % at gt level

 

Sumx(Table,[Price]*1.2)

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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