calculate Milestone

[Anonymous]

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.

[v-yingjl]

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.