Hi I have a column contains values in float, I want to group these values based on the range of values. For example, 5 groups shall equal to (maximum value - minimum value)/5, then set values in the groups accordingly. Because it is a dynamic column its values will change once data is updated. Is there a way to group the values using a calculated field, and how? Thanks. Hope I explained it clearly.
good morning
I would do it with lods - so I could convert the final result to a dimension
for a superstore example
start with this
then this
it will show up as a measure - right click to open it and convert to dimension
it will return something like this in detail
or a summary
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
