Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help with DAX

Hello All I am trying to create the below dax which would replace few texts with my desired output as below: I am facing an error like above. Is there any way we could solve this or any other ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Try like

 

Column = SWITCH( True() ,
CONTAINSSTRING(inbound_inventory_test,inbound_inventory_test[ETS_Mgmt_Follow_up_Comments], "ITW"),"Inbound",
CONTAINSSTRING(inbound_inventory_test,inbound_inventory_test[ETS_Mgmt_Follow_up_Comments], "DTW"), "Delivered to WH",
CONTAINSSTRING(inbound_inventory_test,inbound_inventory_test[PO_Confirmation_Date], " "), "not confirmed",
CONTAINSSTRING(inbound_inventory_test,inbound_inventory_test[manufacturer_name], "zones"), "Zones Service",
(inbound_inventory_test[PO_Confirmation_Date])>TODAY()-3, "New PO",
(inbound_inventory_test[PO_Confirmation_Date])<TODAY()-30,"30+days Open",
"Inbound")

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amitchandak there was a tiny modification below for the dax but it worked out.

    Column2 = SWITCH( True() ,
    CONTAINSSTRING(inbound_inventory_test[ETS_Mgmt_Follow_up_Comments],"ITW"),"Inbound",
    CONTAINSSTRING(inbound_inventory_test[ETS_Mgmt_Follow_up_Comments], "DTW"), "Delivered to WH",
    contains(inbound_inventory_test,inbound_inventory_test[PO_Confirmation_Date]," "), "not confirmed",
    CONTAINSSTRING(inbound_inventory_test[manufacturer_name], "zones"), "Zones Service",
    value(inbound_inventory_test[PO_Confirmation_Date])>TODAY()-3, "New PO",
    value(inbound_inventory_test[PO_Confirmation_Date])<TODAY()-30,"30+days Open",
    "Inbound")

     

     

    I also have one doubt I am generating this using excel formula. In the excel formula they are using OR function on the 3rd line of the dax of you have provided. Below I am pasting the excel formula how can we achieve or function just like the excel formula?

    =IF(A7="","",
    IF(SUMPRODUCT(--ISNUMBER(SEARCH({"ITW"},L7)))>0,"inbound",
    IF(SUMPRODUCT(--ISNUMBER(SEARCH({"DTW"},L7)))>0,"delivered to WH",
    IF(N7="(blank)","not confirmed",
    IF(OR(T7=1,T7=2),
    IF(SUMPRODUCT(--ISNUMBER(SEARCH({"zones"},K7)))>0,"Zones Service",
    IF(N7>TODAY()-3,"new PO",
    IF(N7<TODAY()-30,"30+days open","inbound"))),
    "inbound")))))