Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Richard_Clipsto
Frequent Visitor

Column with maximum amount per category

Hi,

 

I am struggling with a calculated column. I have one column of dates, one with properties, and one with passing rents. I want a column which gives the maximum rent achieved for each property. So this would be the same figure for all time periods for a property but would be different for each property. Then in my table I can see the passing rent for each property at a specific date and then the maximum rent achieved.

 

e.g. what I want to achieve

 

PropertyDateRentMax Rent
A31/01/2024200250
A29/02/2024200250
A31/03/2024250250
B31/01/2024150180
B29/02/2024180180
B31/03/2024180180

 

Thanks,

 

Richard

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

3 REPLIES 3
lbendlin
Super User
Super User

lbendlin_0-1728999132416.png

 

Genius thank you!

SamWiseOwl
Super User
Super User

Hi @Richard_Clipsto 

Calculated column highest rent =

var currProp = [Property]

return

calculate(
max(table[max rent])

,table[property] = currProp )

 

That should create a calculated column that shows next to each property the highest rent it has ever been regardless of date.

 

If you wanted a measure it would be slightly different:

measure highest rent =

var currProp = selectedvalue(table[Property])

return

calculate(
max(table[max rent])

,all(table)

,table[property] = currProp )


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.