Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I create a new column (Device_code) based on 2 digits DeviceName column.
My DAX like: Device_code= LEFT('TableA'[DeviceName ], 2)
After that, I just want to keep Device_code, and delete the original DeviceName column. I tried deleting as normal, but the result got Error value in Device_code
Can anyone help me to deal with it? Thank you.
Solved! Go to Solution.
Of course. After extracting you can concat your columns :
result:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you but besides extracting value in the DeviceName column, I want to extract another column as well. And finally, I can concatenate all of them. The final dataset expect is delete all original columns
Can you give me the best solution to do it?
Of course. After extracting you can concat your columns :
result:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @JennyMilf
You can't delete a column from the data view because you used it and unlike on power query, this step has no "recording" so it needs to have its source column.
You can do the same from PQ in 1 step with "extract" function and it will work
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you but besides extracting value in the DeviceName column, I want to extract another column as well. And finally, I can concatenate all of them. The final dataset expect is delete all original columns
Can you give me the best solution to do it?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |