Forum Discussion
Solved
Dax function is not working
Hi Teams , I want to get the Last Name of customer Name from superstore data . And I wrote the the following dax code and it is not working last_name = RIGHT(orders[Customer_Name],LEN(orders[Cus...
Sudip_J ,Try using
dax
last_name =
VAR space_position = FIND(" ", orders[Customer_Name], 1, LEN(orders[Customer_Name]))
RETURN RIGHT(orders[Customer_Name], LEN(orders[Customer_Name]) - space_position)
Sudip_J ,Try using
dax
last_name =
VAR space_position = FIND(" ", orders[Customer_Name], 1, LEN(orders[Customer_Name]))
RETURN RIGHT(orders[Customer_Name], LEN(orders[Customer_Name]) - space_position)