Forum Discussion

Tejinder's avatar
Tejinder
Helper I
3 years ago
Solved

DAX Help

Thanks for clicking on this This is my sample data:  BarcodeID Order ID BOX sequence TotalBoxes Received(Y/N) received 100620559 1959 1 4 Y 2023-07-18 8:16 100620565 1959 4 4 ...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    Tejinder , Create a new column

     

    Status =
    var _count =
    CALCULATE(
    COUNTROWS('Table'),
    'Table'[Order ID] = earlier('Table'[Order ID]),
    'Table'[Received(Y/N)] = "Y"
    )
    return
    IF(
    _count = 0, "Missing",
    IF(
    _count = MAX('Table'[TotalBoxes]), "Completed",
    "Partially Completed"
    )
    )

     

     

    New measure

     

    StatusMeasure =
    VAR _date = MAX('Table'[received])
    RETURN
    CALCULATE(
    VALUES('Table'[Status]),
    FILTER('Table', 'Table'[received] <= _date)
    )