Nested If And Statement

[Anonymous]

Hi,

I have this formula in BO but am getting error when converting to PBI.

Date Range
=If [Days for Approval] = "Not Approved" Then [Days for Approval]
ElseIf ([Days for Approval (Numeric)]>=0 And [Days for Approval (Numeric)] <=3) Then "0 - 03 Days"
ElseIf ([Days for Approval (Numeric)] > 3 And [Days for Approval (Numeric)] <= 7) Then "04 - 07 Days"
ElseIf ([Days for Approval (Numeric)] > 7 And [Days for Approval (Numeric)] <= 15) Then "08 - 15 Days"
ElseIf ([Days for Approval (Numeric)] > 15 And [Days for Approval (Numeric)] <= 30) Then "16 - 30 Days"
ElseIf [Days for Approval (Numeric)] > 30 Then "31+ Days"

Thank you for the feedback.

[Anonymous]

it worked. Thank you. 🙂

[Vijay_A_Verma · Accepted solution]

Use this

Date Range = 
SWITCH(
    TRUE(),
    [Days for Approval] = "Not Approved", [Days for Approval], 
    [Days for Approval (Numeric)]>=0 && [Days for Approval (Numeric)] <=3, "0 - 03 Days",
    [Days for Approval (Numeric)] > 3 && [Days for Approval (Numeric)] <= 7 , "04 - 07 Days",
    [Days for Approval (Numeric)] > 7 && [Days for Approval (Numeric)] <= 15 , "08 - 15 Days",
    [Days for Approval (Numeric)] > 15 && [Days for Approval (Numeric)] <= 30, "16 - 30 Days",
    [Days for Approval (Numeric)] > 30 , "31+ Days"
)