Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I feel this is the solution you want ,you can concatenate the columns for the appropriate output
I feel this is the solution you want ,you can concatenate the columns for the appropriate output
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.
I am not aware about your exact requirements for concatenation ,but this is what you can do .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |