Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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
Property | Date | Rent | Max Rent |
A | 31/01/2024 | 200 | 250 |
A | 29/02/2024 | 200 | 250 |
A | 31/03/2024 | 250 | 250 |
B | 31/01/2024 | 150 | 180 |
B | 29/02/2024 | 180 | 180 |
B | 31/03/2024 | 180 | 180 |
Thanks,
Richard
Solved! Go to Solution.
Genius thank you!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
81 | |
52 | |
39 | |
35 |
User | Count |
---|---|
95 | |
78 | |
52 | |
49 | |
47 |