cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 IV
Super User IV

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 IV
Super User IV

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors