Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

calculate Milestone

Hi Community,

 

I have the following milestones:
1. A,
2. B,
3. C,
4. D,
5. E,

6. F

 

the milestones are calculated on the basis of a start date and a final date.

currently I make this calculation in excel.

 

Is there a way in power bi to calculate the milestones as follows.

The calculation should be based on the end dates as to whether a milestone has been reached or not.

 

 

Need Help

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    Sorry for replying late. Based on your description, seems not certain what is your expected output.

    Could you please consider sharing more details about this issue for further discussion?

    Sample data and expected output would help tremendously.
    Please see this post regarding How to Get Your Question Answered Quickly:
    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

     

    Best Regards,
    Yingjie Li

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