Tracking changes

[FuManchu]

Hi folks,

First time posting so be kind. Hopefully someone has had a similar report to build and can assist.

I've created a report for employees within my company who are at a certain level.

The report is provided at the beginning of every week and today was the second week of receiving the file. I've had success linking the sharepoint source where the file are hosted, combining them and I have created a filter on the source so I can see the difference in the head count of empoyees at that level from last week to this week.

My query is as follows. Is there a way I can view the additonal people now at that level. E.G Using the tables below as an example. Is there an easy way to highlight/export the details on the additonal person (New colleague) now at the level I am tracking.

Source 1st Oct

Name	Email Address	Job Level	Employee ID
John Smith	[email protected]	4	111
Jane Smith	[email protected]	4	112
John Doe	[email protected]	4	113
Jane Doe	[email protected]	4	114

Source 9th Oct 

Name	Email Address	Job Level	Employee ID
John Smith	[email protected]	4	111
Jane Smith	[email protected]	4	112
John Doe	[email protected]	4	113
Jane Doe	[email protected]	4	114
New Colleague	[email protected]	4	115

Thanks

[v-jiascu-msft]

Hi @FuManchu,

Do you have any other columns in your source? Such as StartDate, Time, which can help with determining this week and last week. Or it's hard to say who is new this week.

Best Regards!

Dale

[FuManchu]

Hi @v-jiascu-msft

The reports (Excel files) when received are named with the deat they were pulled.

Currently I've one call 1st October 2017 & the other 9th October 2017. Once combined in Power BI an additional column is added with this name against the corresponding data.

In short yes. there is a column to differentiate between the two sets of data.

The issue we get is the person themselves may not be new to the file they may have just been promoted from a different role.

E.G John smith was showing as Agent in the data on 1st October 2017 but as manager on 9th October 2017.

Thanks

Liam