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?
Solved! Go to Solution.
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.
https://msdn.microsoft.com/en-us/library/ee634824.aspx
Link above is for the IF Function. See if that'll help you.
Sorry,
Customer ColumnA = IF([ColumnA]>100,"100%",[ColumnA])
Try that DAX formula.
Example screenshot of what I have on mines.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
55 | |
55 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |