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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

employee transfer


i have a transfer table like below.

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.

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



screenshot of salary master






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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.