Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merge rows based on specific data

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

2 Replies

  • nvprasad's avatar
    nvprasad
    Solution Sage

    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