cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sixtoquiles
Helper II
Helper II

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
rajendran
Community Champion
Community Champion

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

View solution in original post

1 REPLY 1
rajendran
Community Champion
Community Champion

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.