Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Solved! Go to 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")
Did I answer your question? If so, please mark my post as a solution!
Proud to be a 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!
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")