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.
Hi,
I have a column with several carachteres wich came from a .txt file. There are about 250 carachteres for each line in the first colum. Is there a way to create customized columns with just a specific carachteres from this first column?
i.e.
Column1(from a .txt file) Column2(customized) Column3(customized) Column4(customized)
ABCDEFGHIJKLMN ABC DEFGH IJKLMN
Hope it is clear.
Thanks!
Solved! Go to Solution.
Is this what you want? Hope this is helpful. Thanks
Column = LEFT(Table2[Column1],3)
Column 2 = MID(Table2[Column1],4,5)
Column 3 = MID(Table2[Column1],10,6)
Proud to be a Super User!
Hi @bsouza,
The solution of @ryan_mayu should be helpful which use dax expression to create the calcualted column.
In addition, you could achieve your desired output in query editor by spliting column which is custom column.
You also could refer to the attachment.
Hope this can help you either!
Best Regards,
Cherry
Hi @bsouza,
The solution of @ryan_mayu should be helpful which use dax expression to create the calcualted column.
In addition, you could achieve your desired output in query editor by spliting column which is custom column.
You also could refer to the attachment.
Hope this can help you either!
Best Regards,
Cherry
Is this what you want? Hope this is helpful. Thanks
Column = LEFT(Table2[Column1],3)
Column 2 = MID(Table2[Column1],4,5)
Column 3 = MID(Table2[Column1],10,6)
Proud to be a Super User!
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 |
---|---|
109 | |
95 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |