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 t...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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's avatar
nvprasad
Solution Sage
6 years ago

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