cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lalit_101
Regular Visitor

employee transfer

Hi,

i have a transfer table like below.

EmployeeCodeAttributeTypeIDAttributeTypeDescriptionNewAttributeIDNewAttributeDescOLDAttributeIDOLDAttributeDescEffectiveDateIsMoveCreatedByCreatedDateUpdateByUpdatedDate
107243Function_Description1052International Business1039Sales and Marketing01-Dec-220D2711/29/2022 9:57  
107244Sub Function_Description1120International Business1088Sales Excellence01-Dec-220D2711/29/2022 9:57  
107350Role_Description2575Dy. Regional Business Manager1778Area Business Manager18-Apr-221D234/1/2022 18:25SYS_TransferJob4/18/2022 0:01
104842Business_Description1018Escorts Construction Equipment1017Escorts Agri Machinery12-Nov-21110284311/15/2021 14:38SYS_TransferJob11/15/2021 14:39

and also a master table like below.

EIDDOJBusinessFunctionSubFunctionRole_DescriptionLWD
123408 Nov 1995Escorts Agri MachineryOperationsCentral Engineering ServicesLead15 Feb 2022
123501 Feb 1996Escorts Agri MachineryResearch and DevelopmentEngineering ServicesLead09 May 2018
123707 Sep 1983Escorts Agri MachineryOperationsMFG Engineering and New ProjectsTeam Manager31 Oct 2017
125501 Jul 1996Escorts Agri MachineryOperationsManufacturing - FTTeam Manager31 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

 

Lalit_101_0-1669806728722.png

screenshot of salary master

Lalit_101_1-1669807754594.png

 

 

 

 

1 REPLY 1
v-jianboli-msft
Community Support
Community Support

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.

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors