Forum Discussion
Solved
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 >...
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.
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.