Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Add the Employee, Department ID, Client ID as dimension and then add measure MIN(Date)
Add the Employee, Department ID, Client ID as dimension and then add measure MIN(Date)
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 |
if([Department ID]<>Previous([Department ID]),Employee & '|' & [Department ID] & '|' & [Client ID] & '|' & Date, null()) as T1;