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)
    )

amitchandak's avatar
amitchandak
Super User
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)
)

Tejinder's avatar
Tejinder
Helper I
3 years ago

Thanks for your help
It does not work, here are the screenshots, 


The idea is that,  i can use a date/time range from a filter. to select a particular window