Rolling forecast - please help

[Madalina123]

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 

[v-shex-msft · Accepted solution]

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