Change values in column based on range

[QuasemS]

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?

[a_mixed_life · Accepted solution]

Sorry,

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

Try that DAX formula.

Example screenshot of what I have on mines.

[a_mixed_life]

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.

[QuasemS]

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

[a_mixed_life · Accepted solution]

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

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

[a_mixed_life · Accepted solution]

Sorry,

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

Try that DAX formula.

Example screenshot of what I have on mines.