Forum Discussion

RobRayborn's avatar
RobRayborn
Helper IV
1 year ago

Rows left out from data source

I have incoming Excel workbooks that I receive monthly. Each workbook gives me one sheet that has columns for, [SKU, SHIP DATE (M/D/Y), and Qantity].  From this data I get how many SKUs are to ship ...
Need Help
Tutorial Requests
dufoq3's avatar
dufoq3
Community Champion
1 year ago

Upload at least 2 of your files with few rows of dummy data i.e. to google drive or dropbox etc and provide at least a screenshot of expected result based on sample data please.

  • RobRayborn's avatar
    RobRayborn
    Helper IV
    1 year ago

    Three Entry Dates, keep an eye on the Date Due December range. It disapears in the Date created 9/26/2024 range.  Without a December 2024 entry of 0, my DAX measure of LASTNONBLANK continues to pick up the December amount from the 8/29/2024 Date created range.

    Date createdPARTNBRDATE DUEQTY DUE
    7/29/2024ABC8/6/2024960
    7/29/2024ABC8/9/202414
    7/29/2024ABC8/23/20246
    7/29/2024ABC9/3/2024480
    7/29/2024ABC9/9/202413
    7/29/2024ABC9/17/2024480
    7/29/2024ABC9/20/202414
    7/29/2024ABC10/1/202417
    7/29/2024ABC10/1/2024480
    7/29/2024ABC11/1/20247
    7/29/2024ABC11/5/2024480
    7/29/2024ABC11/15/202442
    7/29/2024ABC11/26/2024480
    7/29/2024ABC12/6/202416
    7/29/2024ABC12/10/2024640
    7/29/2024ABC12/19/202410
    8/29/2024ABC9/10/20242
    8/29/2024ABC9/20/202411
    8/29/2024ABC9/27/202416
    8/29/2024ABC10/15/2024480
    8/29/2024ABC10/22/2024480
    8/29/2024ABC10/29/202419
    8/29/2024ABC11/5/2024480
    8/29/2024ABC11/12/20246
    8/29/2024ABC11/26/20245
    8/29/2024ABC11/26/2024480
    8/29/2024ABC12/10/202421
    8/29/2024ABC12/19/202421
    9/26/2024ABC8/27/20241
    9/26/2024ABC10/15/2024480
    9/26/2024ABC10/22/2024480
    9/26/2024ABC11/5/2024480
    9/26/2024ABC11/26/2024480
    9/26/2024ABC1/5/2025360
    9/26/2024ABC2/6/2025190