none
IF AND Nested in Calculated Cell RRS feed

  • Question

  • I need to calculate a field in Sharepoint.
    how would I do this, which works in Power BI in Sharepoint Directly?

    Q1.ACV.Priority = IF('Client Assignments'[ACV] = 0,
    0,
    IF('Client Assignments'[ACV] <= 50000,
    1,
     IF('Client Assignments'[ACV] >= 50001 && 'Client Assignments'[ACV] <= 125000,
    2,
     IF('Client Assignments'[ACV] >= 125001 && 'Client Assignments'[ACV] <=200000,
    3,
     IF('Client Assignments'[ACV] >= 200001 && 'Client Assignments'[ACV] <=300000,
    4,
    IF( 'Client Assignments'[ACV] >=300001 && 'Client Assignments'[ACV] <=999998,
    5,
    10)
    )))))

    Wednesday, January 25, 2017 9:41 PM

All replies

  • I figured it out.

    =IF(ACVEntry<=50000,1,IF(AND(ACVEntry>=50001,ACVEntry<=125000),2,IF(AND(ACVEntry>=125001,ACVEntry<200000),3,IF(AND(ACVEntry>=200001,ACVEntry<=300000),4,IF(AND(ACVEntry>=300001,ACVEntry<=999998),4,10)))))

    Wednesday, January 25, 2017 10:23 PM
  • Hi Adam,

    You are right, thanks for sharing, you can mark the reply as answer, it will make others who stuck with the similar issue easier to search for valid solutions in this forum.

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, January 26, 2017 1:48 AM
    Moderator