Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
harry55
Regular Visitor

How do I merge these 37 columns into 1?

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 

1 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

View solution in original post

3 REPLIES 3
lc_finance
Solution Sage
Solution Sage

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

@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

Hi @harry55 ,

 

 

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

Do not hesitate if you have more questions,

 

LC

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.