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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

Create the following Table:

Table 2 = summarize('Table', [first name], [Last name], [Course title],[Completion date],"Status",IF([Completion date]=BLANK(),"Incomplete","Complete"))

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.