Forum Discussion
khaycock
6 years agoHelper I
Combining Data
Hello, Is it possible to create extra lines based on data in other columns? I have three fields that I need to be one field so it can be a generic filter: I'm conscious that amending th...
Greg_Deckler
6 years agoCommunity Champion
You could create a query to get each column (3 queries) and then use an Append query to append them all together.
- khaycock6 years agoHelper I
Hi Greg,
Does the above query work to append? I'm not sure how to append a manually created query as it's not in the Power Query Editor?
- amitchandak6 years agoSuper User
Refer:https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Also in DAX we have union function