Home Forums Power Pivot calculated column with multiple conditions

This topic contains 3 replies, has 2 voices, and was last updated by  tomallan 2 months, 3 weeks ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #10650

    Pam
    Participant
    • Started: 10
    • Replies: 13
    • Total: 23

    Hello,

    Can you please help me write the formula in M or DAX to add column E – Pipeline status in the attached spreadsheet?

    The formula works in Excel but I can not get it to work in Power Pivot.

    Thanks in advance.

    I appreciate your help!

    Pam

    Attachments:
    You must be logged in to view attached files.
    #10652

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2545
    • Total: 2552

    Pam,

    It’s been a while! This worked in the attached workbook:

    =
    IF (
        ISBLANK ( [Projected Build Date] ),
        "No Build Date",
        IF (
            NOT ( ISBLANK ( [Order Cancel Date] ) ),
            "Cancelled",
            IF (
                [Current Order Type] = "S"
                    && ISBLANK ( [VDA Retail Date] )
                    && [Projected Build Date] <= TODAY (),
                "Stock Inventory",
                IF (
                    [Current Order Type] = "R"
                        && ISBLANK ( [VDA Retail Date] ),
                    "Retail Inventory",
                    IF (
                        NOT ( ISBLANK ( [VDA Retail Date] ) ),
                        "Retailed",
                        IF ( [Projected Build Date] > TODAY (), "Order Backlog" )
                    )
                )
            )
        )
    )
    
    Attachments:
    You must be logged in to view attached files.
    #10658

    Pam
    Participant
    • Started: 10
    • Replies: 13
    • Total: 23

    Hi Tom,

    If worked.  Thank you so much!

    Pam

     

    #10660

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2545
    • Total: 2552

    Pam,

    You’re welcome! Nice to re-connect.

    Best regards,

    Tom

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.