Forum Discussion
Averaging Data on Partially Related Tables
Your data model needs some love.
Either specify the application as the main dimension and use the other tables as facts
Or fold the FundedLoan table into the Application table. You can leave the ContractDate and LoanNumber blank for applications that aren't funded yet.
Your quest to show average score per month is potentially not based on any actual data in your fact tables, so you need to create measures for that which transfers the filter context via TREATAS
Generally you want to add a proper calendar table.
See attached for a sample implementation.
Super UserThank you for the concise description. Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
I have edited the original post with the additional data requested. Thank you!
- lbendlin
Your data model needs some love.
Either specify the application as the main dimension and use the other tables as facts
Or fold the FundedLoan table into the Application table. You can leave the ContractDate and LoanNumber blank for applications that aren't funded yet.
Your quest to show average score per month is potentially not based on any actual data in your fact tables, so you need to create measures for that which transfers the filter context via TREATAS
Generally you want to add a proper calendar table.
See attached for a sample implementation.