Forum Discussion

Madalina123's avatar
Madalina123
New Member
8 years ago
Solved

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 

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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