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	John.Smith@mycompany.com	4	111
Jane Smith	Jane.Smith@mycompany.com	4	112
John Doe	John.Doe@mycompany.com	4	113
Jane Doe	Jane.Doe@mycompany.com	4	114

Source 9th Oct 

Name	Email Address	Job Level	Employee ID
John Smith	John.Smith@mycompany.com	4	111
Jane Smith	Jane.Smith@mycompany.com	4	112
John Doe	John.Doe@mycompany.com	4	113
Jane Doe	Jane.Doe@mycompany.com	4	114
New Colleague	new.colleague@mycomany.com	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