adding criteria requirements to Table

[romovaro]

Hi PowerBi community

I need help with the following table. I have a table with Implementation consultant Names and for every month I have the number of customers (CUIDS), number of employees of the project and total € value.

The implementation consultant needs to work on 4 CUIDs x month and 72K€ as an objective. The excel format looks like this:

the last 3 columns are checking if criteria is met. In the example above, is comparing the month of April vs Criteria.

CUID: =IF(N8<4,"CUIDs not met","ok")

GAP to Target = =IF(4-N8<0,0,4-N8)

Starts value: = IF(P8>72, "ok", "starts not ok")

I have the PowerBi table but I am struggling to create the last 3 columns in order to see if monthly perfomance is meeting the criteria.

Any idea how to start?

Thanks

[mh2587 · Accepted solution]

Created three calculated column and replace the column with your desire column name from

CUID: =IF(coulmn<4,"CUIDs not met","ok")

GAP to Target = =IF(4-column<0,0,4-column)

Starts value: = IF(column>72, "ok", "starts not ok")

[romovaro]

HI mh2587

by creating three calculated column you mean I need to right click on the Slippage Report table (name of the table where data comes from) and then selects New Column. ?

Name of the column is Ops & Actuals. And in every column I have 3 values (Count of CUID, Contract EE & start Value". I added the extra measure "Start value Criteria" but it's not working... 

Your formula is only using the Column name but there a re diff fields in the column, right?

Starts value: = IF(column>72, "ok", "starts not ok")