Forum Discussion
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...
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.
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.