Forum Discussion

nix's avatar
nix
Icon for Helper I rankHelper I
1 year ago
Solved

DAX CALCULATION

  I am using this calculated column for column 3,actually it should calculate minimum nad date from nad_custome_date for vessel_id wise(i have selected only one vessel here),then it should cal...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi nix ,

    Based on the testing, please try the following methods:

    1.Create the sample table.

    2.Create the new column to filter the date.

    Column 3 = 
VAR _MIN_VESAEL = CALCULATE(MIN('Missing Arrival/Depart query'[nad_customer_date]), ALLEXCEPT('Missing Arrival/Depart query', 'Missing Arrival/Depart query'[vessel_id]))
VAR _startofpassage = CALCULATE(MIN('Missing Arrival/Depart query'[startofpassage]), ALLEXCEPT('Missing Arrival/Depart query', 'Missing Arrival/Depart query'[vessel_id]))
RETURN
IF('Missing Arrival/Depart query'[nad_customer_date] = _MIN_VESAEL && _MIN_VESAEL = _startofpassage && 'Missing Arrival/Depart query'[nad_type] = 59, 1, 0)

    3.The result is shown below.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
1 year ago

could you pls provide some sample data (not the screenshot) and the expected output?