Results 1 to 3 of 3

Thread: Power Pivot: Match next non-blank item after date match for customer across two table

  1. #1
    Neophyte Phil_T_123's Avatar
    Join Date
    Jul 2020
    Posts
    2
    Articles
    0
    Excel Version
    365

    Power Pivot: Match next non-blank item after date match for customer across two table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I need to create a calculated column in Table_Order that would find the next matching, non-blank Customer Status on or after the current Order Date for the current row Customer #.
    The tricky part is when there is no matching Customer Status in Table_Ship for a Customer # on a particular Order Date (please see the orange highlights). The match then needs to be on the next matching Ship Date for the Customer # where the Customer Status is not blank.

    Please could somebody help me and show me the DAX?

    I've spent a long time Googling and have gotten nowhere. I feel like this should be easy!

    Also please bear in mind that these tables are massively simplified versions of my actual work, and any suggestion to reorganise the tables or start from scratch won't help me, I need some DAX please!

    Thanks in advance!

    Phil.



  2. #2
    Neophyte Phil_T_123's Avatar
    Join Date
    Jul 2020
    Posts
    2
    Articles
    0
    Excel Version
    365
    Apologies, I should have said that this is for Excel Power Pivot (I can't work out how to edit my original post), thanks.

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,523
    Articles
    0
    Excel Version
    Office 365 Subscription
    Attach a workbook. not a picture of it.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •