Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Define project statuses

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"

2 Replies