Merge rows based on specific data

[Anonymous]

Hello community,

I try to make a dax formula that merges multiple rows into 1. The program where this export is from makes a row for every lesson within a course given to a student. It could be that a student gets the lessons both in English and Dutch. But only makes the course in 1 language. In that case the lessons should be completed fully instead of only the language completed because its the same course content; just a different language. So the problem at this moment is that it gives back 2 lessons, the english and dutch where 1 is completed in 1 language but the other lesson is still not completed but this should be completed by merging them together.

The  XX:XX in the "code" field of the course is the same for both languages. And within the the lesson field tright after NL or EN is always the same for both languages. For example, here is the lesson a training, but it could be also a test or another component.

EN {Training}: Phishing

NL {Training}: Phishing

 

Any tips how to merge both languages?

thanks a lot

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nvprasad]

Hi

The below workaround may give you a solution.

1. Create Key with LastName & Coursename without Language.

2. Duplicate table with only key and status. 

3. Filter only "Completed" status records by unchecking blank ones.

4. Do merging(Left outer) to get the status column from the new table.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad