Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a new table based on filters

I have and e-learning data with duplicates across the different columns just like this First Name Last Name Course title Status Completion date James Paul Course A Registered   Jame...
DAX
DAX Data Table
DAX Filtering
DAX function
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks for your response.

    I was able to work around it using power query, relationships and DAX. The data was more complex than I explained.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , one of the two ways

 

summarize(filter(Table, Table[Status] ="Completed"  ), [first name], [Last name], [course], [Status] )

 

or

 

calculatetable(Table, filter(Table, Table[Status] ="Completed"  ))

Shadow_BN515's avatar
Shadow_BN515
New Member
3 years ago

This worked fantasic, just what I was looking for. Thanks for the help