Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.