Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Project Milestones Filter

I want to create a measure to show which milestone my project is on through Power BI. I've created a table which has the milestone, start date and end date. It will refresh once a week to move projec...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

     

     

    Milestone Flag =
    CALCULATE (
    SELECTEDVALUE ( Milestone[Milestone] ),
    FILTER (
    Milestone,
    Milestone[Start] <= MAX ( 'Calendar'[Date] )
    && Milestone[End] >= MIN ( 'Calendar'[Date] )
    )
    )

     

     

    https://www.dropbox.com/s/7z7qg9wmicykzh3/Gingerclaire.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for sharing.

If it is OK with you, please share your sample pbix file's link, then I can try to look into it.

I think it is because of the relationship between the two tables, but I need to check, if possible.

 

Thank you.