Show only distinct data

[Priyanka1902]

Hi All,

I have below data. Now my requirement is I want to show only rows where "Department ID" is different:

Could you please help me to get desired output in Front end?

Original Data table in front End:

Employee	Department ID	Client ID	Date
Freddy	10001	123	28.2.2017
Freddy	10001	123	31.3.2017
Freddy	10001	123	30.4.2017
Freddy	10001	123	31.5.2017
Freddy	10001	123	30.6.2017
Freddy	10001	123	31.7.2017
Freddy	10001	123	31.8.2017
Freddy	10001	123	30.9.2017
Freddy	10001	123	31.10.2017
Freddy	10002	123	30.11.2017
Freddy	10002	123	31.12.2017
Freddy	10002	123	31.1.2018
Freddy	10002	123	28.2.2018
Freddy	10002	123	31.3.2018
Freddy	10002	123	30.4.2018

Expected Data table in front End:

Employee	Department ID	Client ID	Date
Freddy	10001	123	28.2.2017
Freddy	10002	123	30.11.2017

[Mark_Little · Accepted solution]

Add the Employee, Department ID, Client ID as dimension and then add measure MIN(Date)

[Priyanka1902]

Thanks for the answer.

If I don't want to include "Department ID" then how I'll get the below output:

Employee	Client ID	Date
Freddy	123	28.2.2017
Freddy	123	30.11.2017

[mayuringale25]

Hi @Priyanka1902 

if([Department ID]<>Previous([Department ID]),Employee & '|' & [Department ID] & '|' & [Client ID] & '|' & Date, null()) as T1;