cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sixtoquiles Regular Visitor
Regular Visitor

Distinct or Summarize

HI:

 

I have this data, i want to show the teacher and the course, i have a slice with range date.

 

teachercoursedate
johnwordjun
johnexceljun
johnwordjun
johnexceljun
louispowerpointjun
louispowerpointjun
mickyexceljun
mickyexceljun
johnwordjul
johnwordjul
johnwordjul
johnwordjul
louisexceljul
louisexceljul
mickyexceljul
mickyexceljul

 

The output for jun:

 

  
johnword
johnexcel
louispowerpoint
mickyexcel

 

If i change for jul

johnword
louisexcel
mickyexcel
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Distinct or Summarize

Hi @sixtoquiles

 

You can create a summarized table to display this. Go to Modelling -> New Table-> Use this formula:

 

Table_ex_summ = SUMMARIZE(Table1,Table1[teacher],Table1[course],Table1[date])

 

Thanks
Raj

1 REPLY 1
Super User
Super User

Re: Distinct or Summarize

Hi @sixtoquiles

 

You can create a summarized table to display this. Go to Modelling -> New Table-> Use this formula:

 

Table_ex_summ = SUMMARIZE(Table1,Table1[teacher],Table1[course],Table1[date])

 

Thanks
Raj