Solved: Distinct or Summarize

sixtoquiles · ‎07-10-2018

HI:

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

The output for jun:

If i change for jul

Anonymous · ‎07-10-2018

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 · ‎07-10-2018

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

Distinct or Summarize