Forum Discussion
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?
Sorry,
Customer ColumnA = IF([ColumnA]>100,"100%",[ColumnA])
Try that DAX formula.
Example screenshot of what I have on mines.
https://msdn.microsoft.com/en-us/library/ee634824.aspx
Link above is for the IF Function. See if that'll help you.
4 Replies
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.
I'm getting a syntax error when I try to do that in the Query Editor. The "greater than" sign is not valid.
Sorry,
Customer ColumnA = IF([ColumnA]>100,"100%",[ColumnA])
Try that DAX formula.
Example screenshot of what I have on mines.
