Forum Discussion
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...
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 , 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" ))
This worked fantasic, just what I was looking for. Thanks for the help
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.
SOLVED like this:
summarize(filter(Table, Table[Column] = "abc" || Table[Column] = "123") )
