Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Mortgage close - Predictive Analysis

Hi,

 

I am very new to Power BI and I have a requirement that needs to be completed asap.

I have Mortgage data with Loan_Number, Loan_Amount, Loan_Application_Date, Mortgage Type,  Loan_Closed_Date, and Branch.

I need to predict how many loans will be closed and the Loan Amount that will be closed for each day and for each Branch for next one month.

 

Can you please help me achieve this?

I can share sample data

 

Thank you

 

 

Need Help

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Anonymous 

    Can you share some sample data with the desired output to have a clear understanding of your question?
    You can save your data in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi， Anonymous ；

    I tested it. You can count the number of closures and the amount of money for each brand each month, but what is your logical idea for predicting the value for the next month? Average or something? Can you share more information？

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.