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

XR5364

 

How can I generate this new column?

 

Many thanks in advance.

 

8 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

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

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