I have a model with 3 tables: Fin_Data, Dim_Prop, and Dim_Calendar. The Fin_Data table contains financial data for properties, the Dim_Prop contains property attributes, and the Dim_Calendar is a calendar table.
Some of the properties do not have financial data available for every month. I have a column in the Dim_Prop that states what the first month is of financial data (min_date).
Is there some way I can use that information to only filter out properties? It would be easy if the filter in PivotTable I could just select > a min_date, but it doesn't seem like I can do that.
Some of the properties do not have financial data available for every month. I have a column in the Dim_Prop that states what the first month is of financial data (min_date).
Is there some way I can use that information to only filter out properties? It would be easy if the filter in PivotTable I could just select > a min_date, but it doesn't seem like I can do that.