Need help with calculated column dax

[Anonymous]

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 · Accepted solution]

@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]

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.