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_test,inbound_inventory_test[ETS_Mgmt_Follow_up_Comments], "ITW"),"Inbound", " "),
IF(CONTAINS(inbound_inventory_test,inbound_inventory_test[ETS_Mgmt_Follow_up_Comments], "DTW"), "Delivered to WH", " "),
IF(CONTAINS(inbound_inventory_test,inbound_inventory_test[PO_Confirmation_Date], " "), "not confirmed", " "),
 
IF(CONTAINS(inbound_inventory_test,inbound_inventory_test[manufacturer_name], "zones"), "Zones Service", " "),
IF(value(inbound_inventory_test[PO_Confirmation_Date])>TODAY()-3, "New PO", " "),
IF(value(inbound_inventory_test[PO_Confirmation_Date])<TODAY()-30,"30+days Open", "Inbound"),
"inbound")


 

Any idea where am i going wrong or is my dax incorrect? Any help would be much appreciated. Thanks in Advance!

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

2 Replies

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

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Has your problem be solved? If solved, please mark the answer which helps above as a solution. If not, please tell us in order that we can help you further more.

     

    Best Regards,
    Community Support Team _ xiaosun

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