cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
romovaro
Super User
Super User

adding criteria requirements to Table

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:

romovaro_0-1645527170240.png

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.

romovaro_1-1645527990617.png

 

Any idea how to start?

 

Thanks

 

 

 

 

 

 

1 ACCEPTED SOLUTION
mh2587
Super User
Super User

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")



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/

View solution in original post

2 REPLIES 2
mh2587
Super User
Super User

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")



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/

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")

romovaro_0-1645529837537.png

 

 

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors