Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |