Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Learner86
Helper I
Helper I

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.

 

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8
VahidDM
Super User
Super User

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:

 

VahidDM_0-1632989712780.png

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!

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

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 

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

@VahidDMthank you very much for your help.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.