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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pricey79
Helper V
Helper V

Help with an IF (I think) statement please

Hello, I was hoping someone could help me please. 

I have a column called ID . Then there is a column (Column 1) with names that have three letters in front of them then a dash before the name starts.

Then there is a column with just names (Column 2)

I have merged these 2 columns together now called Column 3.

I need the ID column to show the ID of both these columns, but at the moment its only showing the one with just names (Column2)

 

Is there something I can write in Power Query or as a calculated table in data view that says something like, if Column 3 shows names then show this in ID column, and if column 3 shows names with three letters in front, then show that one in the ID column?

 

I hope that makes sense?

 

Thank you for any help

1 ACCEPTED SOLUTION

@Pricey79 

why not split column 1 in PQ?

1.PNG2.PNG

and you just merge column 1.1 and column2





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
ryan_mayu
Super User
Super User

could you pls provide the sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ryan_mayu Thank you

Does this help?

Pricey79_2-1676452528896.png

 

 

 

@Pricey79 

why not split column 1 in PQ?

1.PNG2.PNG

and you just merge column 1.1 and column2





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks very much @ryan_mayu 

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.