How do I merge these 37 columns into 1?

[harry55]

I am following an economic education, and I have been commissioned to perform various assignments in power bi. The problem is that this must be done independently, and no lessons are given. So I now run into a problem that I've been working on all night but can't solve it. One of the assignments is to show how many men and women are present in a given flight and I have to show this in a return flight. I have come so far to show how many men and women are on separate trips, but I have no idea how I can merge these 37 columns into one.

https://imgur.com/T1l9RDX 

[lc_finance]

Hi @harry55 ,

Can you share a Power BI sample?

You can share it by uploading it to One Drive, Google Drive or similar and then including a link in your reply.

I look forward to helping you,

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

[harry55 · Accepted solution]

@lc_finance I think I have found a solution to the problem. I have added an extra column in the table of flights for return flights and started filtering with it. I have no idea if this also shows the correct results, but I didn't get any further. Below the link to the document.

https://drive.google.com/drive/folders/1X13mvuMZjq__MzY4TTrokfZs7RNzP_vH?usp=sharing

[lc_finance]

Hi @harry55 ,

glad to hear that you should have found a solution for it.

Do not hesitate if you have more questions,

LC