Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rh_pg
Contributor II

RangeMax does not count with new columns - custom name label

Hi all, I am looking for solution how to use RangeMax for columns which are named via Label.

My column is named TrfSlvnft via Label, whole column is calculation. But it looks like RangeMax does not want to work with custom named columns. I tried column(5) for example, did not work. Maybe I googled and searched here topics wrong, but I did not find solution in an hour. Could you help?

 

Example of name of my column:

rh_pg_0-1702997001891.png

 

how I want to use it:

rh_pg_1-1702997001832.png

 

 

does not work 

rh_pg_2-1702997001640.png

 

 

Labels (3)
2 Replies
Or
MVP

Referencing columns in this way tends to be problematic if it works at all. Referencing using Column(n) should work, though. However, have you considered using master items for your measures instead? You can reference those directly based on their name. If that's not an option, the best bet is to spell out the formula instead of trying to reference the column name.

Do note that your expression still has to be valid when you reference the master item, insofar as aggregations. If it isn't, you won't get a valid result no matter which method you use.

rh_pg
Contributor II
Author

Thank you for fast response. I have no option to create new Master item, but I got an idea few second ago that I do not need particular column as in excel, I put all formulas directly to rangemax() and it worked!! 🙂