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

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

       

       

       

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