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
Highlighted
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
Highlighted
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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 375 members 3,855 guests
Please welcome our newest community members: