Power BI - Need help creating a Milestone plus 30 days calculation!

[Anonymous]

I have a Project Online instance with Power BI desktop, and I want to create a solution that displays FUTURE (NEXT 30 DAYS) milestones task. Does anyone have a solution?

Please note that today's date is represented by the date the milestone falls on.

If you have any additional questions or needs further clearification, please do not hesitate to ask.

Thank you in advance for your assistance.

Bue Williams

[Anonymous]

Thank's Amit for the assistance. I used the formula as described and it produced the solution I desired.

[Anonymous · Accepted solution]

Hi Amit, unfortunately this did not resolve the issue.

The answer to your question is; no, I do not have forecast data.

I am working with projects from my project online instance and is looking to see what milestones occur within the next 30 days, from the date of my current milestone in a project schedule. 

[Anonymous]

Hi @Anonymous ,

According to your statement, I think you get data from Project Online in Power BI Desktop. In Power BI, we will calculate values based on the value we determind (like var function ) or in data model. So, if there is no value in data model or there may be current values but we do not a calculate logic for future, we couldn't get forecast by calculation.

If you want to get forecast value plus 30 days based on day in current row, try this code.

Forecast plus 30 days =
CALCULATE (
    SUM ( Project[VALUE] ),
    FILTER (
        ALLEXCEPT ( Project, Project[Project] ),
        Project[Date]
            = MAX ( Project[Date] ) + 30
    )
)

Result is as below.

If this reply still couldn't help you solve your problem, please share a sample file with us and show us a screenshot with the result you want.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Do you already have fore cast data.

Assume no date is selected, you can get next 30 days of date like

calculate([forecast measure], filter(Table, Table[Date] >= today()  && Table[Date] <= today()+30 ) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.