employee transfer

[Lalit_101]

Hi,

i have a transfer table like below.

EmployeeCode

AttributeTypeID

AttributeTypeDescription

NewAttributeID

NewAttributeDesc

OLDAttributeID

OLDAttributeDesc

EffectiveDate

IsMove

CreatedBy

CreatedDate

UpdateBy

UpdatedDate

1072

43

Function_Description

1052

International Business

1039

Sales and Marketing

01-Dec-22

0

D27

11/29/2022 9:57

1072

44

Sub Function_Description

1120

International Business

1088

Sales Excellence

01-Dec-22

0

D27

11/29/2022 9:57

1073

50

Role_Description

2575

Dy. Regional Business Manager

1778

Area Business Manager

18-Apr-22

1

D23

4/1/2022 18:25

SYS_TransferJob

4/18/2022 0:01

1048

42

Business_Description

1018

Escorts Construction Equipment

1017

Escorts Agri Machinery

12-Nov-21

1

102843

11/15/2021 14:38

SYS_TransferJob

11/15/2021 14:39

and also a master table like below.

EID	DOJ	Business	Function	SubFunction	Role_Description	LWD
1234	08 Nov 1995	Escorts Agri Machinery	Operations	Central Engineering Services	Lead	15 Feb 2022
1235	01 Feb 1996	Escorts Agri Machinery	Research and Development	Engineering Services	Lead	09 May 2018
1237	07 Sep 1983	Escorts Agri Machinery	Operations	MFG Engineering and New Projects	Team Manager	31 Oct 2017
1255	01 Jul 1996	Escorts Agri Machinery	Operations	Manufacturing - FT	Team Manager	31 Mar 2019

i also have 2 more table 1 is Salary master and another is employee requisition (requisition is for upcoming joining)

already created date calander table.

i also created live headcount monthend logic basis on DOJ and LWD

now i want is in my visual if employee transfer from (for eg: from one function to another function) then system should shoud employee count basis on there previous attribute.

for eg :- in transfer table (on top)  if i use slicer function desciption "Sales and Marketing" then from nov visual onwards employee count reduce by 1 and increase by 1 in International Business. if no slicer are selected then it remain same.

same with cost if that employee cost reduce from sales and marketing and increase in Internation business

screenshot of salary master

[v-jianboli-msft]

Hi @Lalit_101 ,

What does your table Salary master and employee requisition look like?

What is your live headcount monthend logic basis on DOJ and LWD?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.