cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
romovaro
Post Patron
Post Patron

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors