Table with 2 columns, employment and detremination date of employees. My Report should show me employees who still work

Anything related to PowerPivot and DAX Formuale
Tendo
Posts: 2
Joined: Thu Mar 01, 2018 1:07 am

Table with 2 columns, employment and detremination date of employees. My Report should show me employees who still work

Postby Tendo » Thu Mar 01, 2018 6:55 pm

Hello,

I´m new to this forum and powerpivot as well. I hope somebody can help me with my little powerpivot issue.

I have a 4 different tables.

The first one "Resource" includes 3 different columns, Name of employee, Employment Date & Termination Date.

The second one "SP_Day" includes the columns, name of employee,activity date, hours of overtime.

The third table contains name of employee, Job Description, Quantity.

The last one is the calendar table.

I created a dashboard which has two reports. The first one shows sickness absence rate for each employee and the second one the hours of overtime. The values of each report is fine. But my problem is, that they show each employee in the history of the company. I added a timeline slicer to show me just the employee for example at the end of 2017.

Can anybody help me to solve my problem?

I hope I explained clear enough the probleme I have. Sorry my bad explanaition and even worse english, I´m german.

Thanks for every answer and help!

Tendo

benholmes
Posts: 9
Joined: Tue Jan 30, 2018 9:22 pm

Re: Table with 2 columns, employment and detremination date of employees. My Report should show me employees who still w

Postby benholmes » Thu Mar 01, 2018 9:06 pm

Hi Tendo,

If you can provide some sample data, with all your measures/relationships in place as per your 'live' data set it'll make it a lot easier to help you out.

Tendo
Posts: 2
Joined: Thu Mar 01, 2018 1:07 am

Re: Table with 2 columns, employment and detremination date of employees. My Report should show me employees who still w

Postby Tendo » Thu Mar 01, 2018 11:46 pm

Hi benholmes,

thanks for your answer.

You are right, without any data set it isn´t possible to understand...

I hope my data makes any sence because it is a test data set.


Thanks
Tendo
Attachments
Perso_Test.zip
(1.89 MiB) Downloaded 46 times


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 7 guests