cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Madalina123 Visitor
Visitor

Rolling forecast - please help

Hello guys,

 

I am new to Power BI and I just got stuck to the following problem. I have 2 columns one showing the date when a role has been opened (Date role posted on Share) and a column with a date when a role has been closed (Date offered).

I would like to be able to create a rolling forecast bar chart that shows me the number of roles I have had opened each month?

 

Your help would be greatly appreciated!

 

Madalina 

Rolling forecast.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Rolling forecast - please help

Hi @Madalina123,

 

You can refer to below link to know how to write measure to calculate with specific duration:

Analyzing events with a duration in DAX

 

Then use above data to create line chart with forecast line.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Rolling forecast - please help

Hi @Madalina123,

 

You can refer to below link to know how to write measure to calculate with specific duration:

Analyzing events with a duration in DAX

 

Then use above data to create line chart with forecast line.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |