cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors