cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Help needed in power query

Hi 

 

Can some one helpme.I am new to powerBI.I have a scenario explained below.

 

I have two tables 

 

Table 1

 

col 1    col 2    col3

abc

bnn

fffg

hhh

 

Table 2

 

col 1

 

04/04/2018

12/04/2018

 

desired output

 

Table1

Table 1

 

col 1    col 2    col3 col4

abc                         abc_04/04/2018

abc                         abc_12/04/2018

bnn                         bnn_04/04/2018

bnn                          bnn_12/04/2018

fffg                         fffg_04/04/2018

fffg                          fffg_12/04/2018

hhh                        hhh_04/04/2018

hhh                        hhh_12/04/2018

 

Someone please help to get it done using powerquery/DAX

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Help needed in power query

Screenshot_2.pngI feel this is the solution you want ,you can concatenate the columns for the appropriate output

View solution in original post

5 REPLIES 5
Highlighted
Helper I
Helper I

Re: Help needed in power query

@ImkeF

 

Power query xpert,kindly help ..

Highlighted
Helper I
Helper I

Re: Help needed in power query

Highlighted
Continued Contributor
Continued Contributor

Re: Help needed in power query

Screenshot_2.pngI feel this is the solution you want ,you can concatenate the columns for the appropriate output

View solution in original post

Highlighted
Helper I
Helper I

Re: Help needed in power query

Thank You So much for your help.

 

For each entry in col 1 of table1 i have different patterns to follow while concatenating.So i may need an IF to concatenate.

Can we do the cross join and if conditions in one step.

Highlighted
Continued Contributor
Continued Contributor

Re: Help needed in power query

I am not aware about your exact requirements for concatenation ,but this is what you can do . Screenshot_3.png

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors