Forum Discussion

Lily36876's avatar
Lily36876
Helper II
3 years ago
Solved

Columns Data Reorganization

Hi Guys, I want to brief product name , all data comes from sql server not csv. first three columns data is existing in  same table , but product name is too long to show on dashboard, so I want t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a new column.

     

     

     

    Ideal Type CC =
VAR _newproduct =
    REPLACE ( Data[Product], 1, LEN ( Data[Brand] ), "" )
RETURN
    Data[Short Name] & _newproduct
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

 

 

Ideal Type CC =
VAR _newproduct =
    REPLACE ( Data[Product], 1, LEN ( Data[Brand] ), "" )
RETURN
    Data[Short Name] & _newproduct
  • Lily36876's avatar
    Lily36876
    Helper II
    3 years ago

    Thanks for reply!! Is really useful for me