Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Mortgage close - Predictive Analysis



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



Community Support
Community Support

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.

Frequent Visitor

Hi, @Fowmy 

Here is the link for sample data-Analysis



Super User
Super User


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.

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors