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!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!