Define project statuses

[Syndicate_Admin]

Good morning to the community,

I've recently started my entry into Power Bi.

I come across the following:

I have a "Consulta_proyectos" table that I have a measurement with the projected costs for each project.

Then, in a table related to the previous one of 1 to 1, I have the real costs of each project. Both actual and projected costs are measured.

I want to define a project "status", based on the % of projected actual/total costs. For example: If (Measure[Actual Costs]/Measure[Total Costs]>15% and <35%,"Initial Phase".

There would be 5 phases: Material purchase (<15%), initial phase (>15% and <35%), execution (>35%, <75%), final (>75%, <100%) and Budget exceeded (>100%).

Could you help me?

Thanks a lot.

Best regards

If actual/total costs = 25%, "Initial phase"

[Syndicate_Admin]

Thank you very much, I have done perfectly!

[amitchandak · Accepted solution]

@Syndicate_Admin , Based on what I got seem like you need a bucket on a measure.

if yes then refer this blog or video, you need an independent table and group by for that

https://app.powerbi.com/view?r=eyJrIjoiYmFmMTc0NzYtYzMzNS00NTU0LWFjNGYtODc4ZjA0ODM0MzVjIiwidCI6ImVhO...

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...