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
    4 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.

StefD's avatar
StefD
Frequent Visitor
1 year ago

Works for me very well too. Is there an opition to have 2 ctriterias listed? as .... {"mm" , "xx"}  ... is not working form me. Thanks in advance.

StefD's avatar
StefD
Frequent Visitor
1 year ago

SOLVED like this:

summarize(filter(Table, Table[Column] = "abc" || Table[Column] = "123") )