Forum Discussion

Sudip_J's avatar
Sudip_J
Helper I
1 year ago
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...
Need Help
Tips and Tricks
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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's avatar
Sudip_J
Helper I
1 year ago

Hi bhanu,
thanks for providing the solution .
I am requesting to can  you please provide another way to get last name ?