Forum Discussion

sixtoquiles's avatar
sixtoquiles
Helper II
8 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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