Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help with calculated column dax

Hello All. I am using the below dax for my calculated column and it is created with out any errors but, the entire column is blank after the dax. Column = SWITCH( IF(CONTAINS(inbound_inventory_tes...
  • amitchandak's avatar
    amitchandak
    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")

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