Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Any idea where am i going wrong or is my dax incorrect? Any help would be much appreciated. Thanks in Advance!
Solved! Go to Solution.
@vashu-123 , 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")
Hi @vashu-123 ,
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.
@vashu-123 , 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")