Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have two columns that I would like to UNION into one column (like how you'd do in SQL) - is there any way to do this in Power BI. I dont want to merge them - I just need them combined into one column.
Thanks in advance :
Solved! Go to Solution.
Hi,
starting from this
insert a step after
and modify your step this way
=Table.ToColumns( #"Changed Type")
retransform to table
and expand to new rows
then remove duplicates
change type to date
and sort ascending
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
you can use a conditional column
Hi -
Here is a simple solution using M-code:
This assumes you have a table represented by a query called "Dates", it has 2 columns - Date1 and Date2:
let
Col1 = Dates[Date1], // Creates a column object from Date1 of the table Dates
Col2 = Dates[Date2], // Creates a column object from Date2 of the table Dates
NewTable1 = Table.FromColumns({Col1}), // Creates a new table made up only of column 1
NewTable2 = Table.FromColumns({Col2}), // Creates a new table made up only of column 2
NewTable3 = Table.Combine({NewTable1,NewTable2}) // Uses the Table.Combine function - merges the 2 tables
in
NewTable3 // Returns the new table
Hope this helps!
Peter
Both solutions worked. Thanks both 🙂
Hi -
Here is a simple solution using M-code:
This assumes you have a table represented by a query called "Dates", it has 2 columns - Date1 and Date2:
let
Col1 = Dates[Date1], // Creates a column object from Date1 of the table Dates
Col2 = Dates[Date2], // Creates a column object from Date2 of the table Dates
NewTable1 = Table.FromColumns({Col1}), // Creates a new table made up only of column 1
NewTable2 = Table.FromColumns({Col2}), // Creates a new table made up only of column 2
NewTable3 = Table.Combine({NewTable1,NewTable2}) // Uses the Table.Combine function - merges the 2 tables
in
NewTable3 // Returns the new table
Hope this helps!
Peter
Hi,
starting from this
insert a step after
and modify your step this way
=Table.ToColumns( #"Changed Type")
retransform to table
and expand to new rows
then remove duplicates
change type to date
and sort ascending
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
you can use a conditional column
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
71 | |
67 | |
25 | |
18 | |
12 |