Help needed in power query

[Surya1]

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

[Hardik · Accepted solution]

I feel this is the solution you want ,you can concatenate the columns for the appropriate output

[Surya1]

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.

[Hardik]

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

[Surya1]

@ImkeF

Power query xpert,kindly help ..

[theitguy]

This one might help you: Cartesian Join of two queries to create ...

Table.ExpandListColumn