cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QuasemS
Frequent Visitor

Change values in column based on range

Hi,

 

Is there a way to select a specific column, and then change some of it's values to something else, based on it's range. For example, I'm trying to change a percentage column, where anything > 100% should just be converted to 100%.

 

Is there a way to set the conditions for value replacement in the query editor?

2 ACCEPTED SOLUTIONS

Sorry,

Customer ColumnA = IF([ColumnA]>100,"100%",[ColumnA])

Try that DAX formula.

 

Example screenshot of what I have on mines.

 

DAX.PNG

Kris

View solution in original post

https://msdn.microsoft.com/en-us/library/ee634824.aspx

 

Link above is for the IF Function. See if that'll help you.

Kris

View solution in original post

4 REPLIES 4
a_mixed_life
Resolver I
Resolver I

You could always create a new column with the logic you're trying to implement.

 

Column A = 110%

 

New Column A = IF ColumnA is > 100% Then 100%.

 

That way you still have the original data of your column in case you need it.

Kris

I'm getting a syntax error when I try to do that in the Query Editor. The "greater than" sign is not valid.

https://msdn.microsoft.com/en-us/library/ee634824.aspx

 

Link above is for the IF Function. See if that'll help you.

Kris

Sorry,

Customer ColumnA = IF([ColumnA]>100,"100%",[ColumnA])

Try that DAX formula.

 

Example screenshot of what I have on mines.

 

DAX.PNG

Kris

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors