Forum Discussion
Change values in column based on range
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.
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.
https://msdn.microsoft.com/en-us/library/ee634824.aspx
Link above is for the IF Function. See if that'll help you.
