Forum Discussion
Solved
tracking real estate data
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 corr...
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.
audreygerred
Super User
Super UserHello! 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.
This is too smart! Thanks a lot, I'll give it a try.