Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi everyone,
I have the following column
Acquisition
XR3582 Station
Software
XR2563 Improvment
Monitoring
XR5364 Analytics
I want to have a new column like this
XR3582
XR2563
XR5364
How can I generate this new column?
Many thanks in advance.
Solved! Go to Solution.
Download this file: https://gofile.io/d/n6vBZ8
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @Learner86
I'm not sure I understand your request very well or not, but try something like this to add a new column with dax to your table:
If(left([Acquisition],2)="XR",left([Acquisition],6),blank())
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @VahidDM
thank you very much for your proposed solution, unfortunately that does not help me. In the column I want to keep the part with XR...(for example XR3582) without the additional text like Station or Improvment.
Hi @Learner86
Do you want something like this:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @VahidDM,
this is exatly what I need. But when I apply this formula then I get empty rows. Do you habe an idea why?
Thank you very much!
Can you share a sample of your data in a table format?
Copy and past that to excel and then here. (Remove all sensitive data)
Appreciate your Kudos!!
Hi @VahidDM
this is a sample of my data
Position |
XR4667 Proof of Value |
XR4675 Software |
XR4683 Digitalisation |
Machine |
Market |
As I said I want to keep in an new column just the part with XR and the number like XR4667.
I want to have a new column like this:
Position |
XR4667 |
XR4675 |
XR4683 |
Download this file: https://gofile.io/d/n6vBZ8
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
User | Count |
---|---|
25 | |
21 | |
20 | |
13 | |
13 |
User | Count |
---|---|
40 | |
28 | |
27 | |
23 | |
21 |