tracking real estate data

[chris1234512]

I have generic property level information (Property Name, address, size, property type, sf, etc.) that I'd like to filter in power bi. In addition to this, I have property level financials which correlate to each Property Name. I'd like to be able to filter by date as these will change throughout time (2023 Revenue for property name A vs 2022 Revenue for property name A as an example). Should I have two fact tables to get this done? IE one for the property level information and one for the financial information? The info will be pulled from basic excel spreadsheets. Here's what I currently have.

[audreygerred · Accepted solution]

Hello! It sounds like your financial table should serve as the fact table and the property table would be the dimension table that can be used to filter. You would connect the Property Dim table to the Financial Fact table usining a key for the property and a Date table would also connect to Financial table.

[chris1234512]

Hello, I'm running into a similar scenario. I have different property types (Multifamily, retail, office etc). With some of their own unique property information. Should all of these property types be in one dimension sheet? Or would it be more efficient to have one sheet for multifamily, one for retail, etc. The idea would be then to link them to a financial sheet that includes sales data (A property sold on xyz date for $abc). I'm leaning towards 1 dimension sheet with a column specifiying which property type it is. There will be some "blanks" for certain property types (Multifamily has 'units' but retail only has 'total square footage' for the size of the property). Any thoughts? Happy to send screen shots/discuss further for clarity.

[Ashish_Mathur]

Hi,

Based on the limited informatin that you hve shared, there should be 1 Dim table for all property types.

[chris1234512]

This is too smart! Thanks a lot, I'll give it a try.