Reply
SelflearningBi
Helper III
Helper III
Partially syndicated - Outbound

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

Syndicated - Outbound

@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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

Syndicated - Outbound

@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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)