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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
romovaro
Post Partisan
Post Partisan

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



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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.