Forum Discussion
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...
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
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
Thanks for reply!! Is really useful for me