cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Anonymous
Not applicable

## Real Estate Portfolio cumulative area per year

Hello

I have been asked to present a real estate portfolio visual which shows total cumulative sqr ft per year according to lease expiry.

I have building, sqr ft and the lease exiry

Building A  - 100sqft - Expire 2020

Building B - 200sqft - Expire 2022

Building C - 300sqft - Expire 2024

So 2019 = 600sq ft, 2020 = 500sq ft, 2021 = 500 sq ft, 2022 = 300sq ft etc

Please can you assist as I've no idea how to sum if within the lease

Thanks

1 ACCEPTED SOLUTION
Resolver III

This should work. It works with the limited data that you provided. I made the table with both versions just in case:

The measure that I created is the following:

```Answer =
VAR selYear = SELECTEDVALUE(Table2[Expire Year])
RETURN
CALCULATE(
SUM(Table2[sqft num]),
ALL(table2),
Table2[Expire Year] > selYear
)```

You can see the result below the years I retrieved from the Expire Year column:

4 REPLIES 4
Resolver III

In the table, is the square footage listed as 100sqft or just the number 100?

Anonymous
Not applicable
Just the number. Date is an actual date (dd/mm/yyyy) field although I have a column which calculates the year value
Resolver III

This should work. It works with the limited data that you provided. I made the table with both versions just in case:

The measure that I created is the following:

```Answer =
VAR selYear = SELECTEDVALUE(Table2[Expire Year])
RETURN
CALCULATE(
SUM(Table2[sqft num]),
ALL(table2),
Table2[Expire Year] > selYear
)```

You can see the result below the years I retrieved from the Expire Year column:

Anonymous
Not applicable
Thank you @vega that has worked very nicely. I’ve leanrned a lot with that variable

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors