Forum Discussion

Learner86's avatar
Learner86
Helper I
4 years ago
Solved

DAX equivalent like command in SQL

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 XR53...
  • VahidDM's avatar
    VahidDM
    4 years ago

    Learner86 

     

    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!!

Learner86's avatar
Learner86
Helper I
4 years ago

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.

VahidDM's avatar
VahidDM
Super User
4 years ago

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!!

 

 

 

  • Learner86's avatar
    Learner86
    Helper I
    4 years ago

    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!

    • VahidDM's avatar
      VahidDM
      Super User
      4 years ago

       Learner86

       

      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!!

      • Learner86's avatar
        Learner86
        Helper I
        4 years ago

        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