Mortgage close - Predictive Analysis

[NXD210907]

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

[v-yalanwu-msft]

Hi， @NXD210907 ；

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.

[NXD210907]

Hi, @Fowmy 

Here is the link for sample data-Analysis

 https://drive.google.com/file/d/1Y6UeYDwLJXAAIlEr7msxPzhkRnD0fCk2/view?usp=sharing

Thanks 

[Fowmy]

@NXD210907 

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.