Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.