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.   teacher course date john word jun john excel jun john word jun john ex...
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

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