Forum Discussion

Casperserven1's avatar
3 years ago
Solved

Only display unique value

Here is an interesting conumdrum. In this data here we have some Employees who have achieved  various skill levels against various skill types. The Skill types are not included here. What we are  try...
  • Casperserven1's avatar
    3 years ago

    ...and worked out my own solution create a table using summarize:

    test = SUMMARIZE (Data2, Data2[Name], Data2[Date], "maxrate", MAX(Data2[Level]))