cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steph-Ved Frequent Visitor
Frequent Visitor

Financial forecast

Hi,

I try to make a financial forecast graphic on current contracts. I have a sharepoint database with the columns "initial date of the contract", "end date of contract" and "monthly amount".
I can not figure out how to make powerBi apply the "monthly amount" every month between the two dates.

If someone has an idea.

 

Thanks a lot

 

Stephane

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Financial forecast


Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Financial forecast


Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Community Support Team
Community Support Team

Re: Financial forecast

Hi @steph-Ved

From my view, your requirement is possible to achieve with power bi,

Could you share some data with me and let me know the logic for forecast so taht i can figure out with DAX?

 

some similar case sloved with power bi below

Finance Forecast using DAX

 Take Advantage of Forecasting in Power BI with the Analytics Pane

 

 

Best Regards

Maggie

 

steph-Ved Frequent Visitor
Frequent Visitor

Re: Financial forecast

Hi @Greg_Deckler

 

I'm sorry for the response time, I was able to test your solution in the last few days and that's exactly what I wanted.

I use Periodic Billing solution. The coding is a little scary for a neophyte like me, but it works very well and finally quite easy to adapt. 

So thanks a lot. 

 

Stephane

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 2,914 guests
Recent signins:
Please welcome our newest community members: