Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
nikcon
New Member

Ordrebook

Hi 

I have a problem with ordrebook value
I work in a consulent company, and i want to se the orderbook over time. 
so i can follow how much we have in each month in the next month.

The data i have is, the project startdate, enddate, budgetamount on each project, i already have an date tabel, but somehow i cant figure out 🙂

Hopefully someone can help

4 REPLIES 4
nikcon
New Member

I have the following -
"last reg" - last registration on the case
"project enddate" 
"reg amount" - Whats registrated 
"Rest budget" whats left of the budget 
"month" - The period between last reg and end date. ( i already have a date table
So now i want divide "rest budget" on to the next month within the last reg and end date 🙂
Sorry for the slow answer - hope u can help me out 🙂 

Skærmbillede 2023-04-27 182801.jpg

Hi,

Your question is not clear.  Share raw data in a format that can be pasted in an MS Excel file and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

Share some data (in a format that can be pasted in an MS Excel workbook) and also show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
vanessafvg
Super User
Super User

are you able to provide some sample data?

 

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.