Forum Discussion

Ericwhv's avatar
Ericwhv
Helper II
4 years ago
Solved

DAX - Measurement support

Hi All   Thank you everyone! Last time, I asked to build a measurment about how to check the "Last Leg" Pervoius Question   Now, i am not sure if anyone could help me to build a measurement to ...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Ericwhv 
    I added two columns, one calculate the Leg Check and the 2nd for the  result

    Leg Check = 
SWITCH(
    TRUE(),
    LEFT(Table6[Consol Lane],3) = Table6[GNR Orign] , "First Leg",
    RIGHT(Table6[Consol Lane],3) = Table6[GNR Dest] , "Last Leg",
    "Transit Leg"
)
    Check = 
VAR __LegCheck = Table6[Leg Check]
VAR __HB = Table6[HB]
VAR __T1 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[HB] = __HB)
VAR __T2 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[Arrival date]=BLANK() && Table6[HB] = __HB)
VAR __T3 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[Arrival date]<>BLANK() && Table6[HB] = __HB)
RETURN
    SWITCH(
        TRUE(),
        ISEMPTY(__T1), "Not Arrived, Missing last leg",
        NOT ISEMPTY(__T2), "Not Arrived",
        NOT ISEMPTY(__T3), "Arrived"        
)


    Result

     










Fowmy's avatar
Fowmy
Super User
4 years ago

Ericwhv 
I added two columns, one calculate the Leg Check and the 2nd for the  result

Leg Check = 
SWITCH(
    TRUE(),
    LEFT(Table6[Consol Lane],3) = Table6[GNR Orign] , "First Leg",
    RIGHT(Table6[Consol Lane],3) = Table6[GNR Dest] , "Last Leg",
    "Transit Leg"
)
Check = 
VAR __LegCheck = Table6[Leg Check]
VAR __HB = Table6[HB]
VAR __T1 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[HB] = __HB)
VAR __T2 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[Arrival date]=BLANK() && Table6[HB] = __HB)
VAR __T3 = FILTER( Table6, Table6[Leg Check] = "Last Leg" && Table6[Arrival date]<>BLANK() && Table6[HB] = __HB)
RETURN
    SWITCH(
        TRUE(),
        ISEMPTY(__T1), "Not Arrived, Missing last leg",
        NOT ISEMPTY(__T2), "Not Arrived",
        NOT ISEMPTY(__T3), "Arrived"        
)


Result

 










Ericwhv's avatar
Ericwhv
Helper II
2 years ago

Hi Fowmy 

not sure if you could help me?
the above quesiton, what if i add one more status?
If the shipment is not "Last Leg" AND the "Delivery date" is there
then, the status need to show "Not Arrived - DLV presented"

Thank you for your help!!