Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
romovaro
Responsive Resident
Responsive Resident

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


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



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


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



romovaro
Responsive Resident
Responsive Resident

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors