How do i show employees who left or join the company in any of the month. For eg. Nov 2021.

[Anonymous]

Hi everyone, I have a question. In my visualization chart, i am showing from Jan 2022 to Jan 2022. In the chart, i have selected Nov 2021. Is there a way to show which employees left the company on Nov 2021. Likewise for those who joined the company on Nov 2021 or any of the other months.  It is showing nothing on my table. Is it supposed to be in this way?

[v-henryk-mstf]

Hi @Anonymous ,

Based on your description, I think we can refer to the following formula.

M_reult =
VAR a_in =
    CALCULATE (
        MAX ( 'Table'[Inflow] ),
        SELECTEDVALUE ( 'Table'[Date] ) = 'Table'[Date]
    )
VAR b_out =
    CALCULATE (
        MAX ( 'Table'[Outflow] ),
        SELECTEDVALUE ( 'Table'[Date] ) = 'Table'[Date]
    )
RETURN
    "inflow:" & a_in & ";" & "outflow:" & b_out

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

Best Regards,
Henry

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

[Anonymous]

Hi Sir, thank you for your response. Greatly appreciated.

These are the columns used to generate the chart.

So i have 3 calculated measures

- Inflow 

Code:  Inflow = 0 + CALCULATE(COUNTROWS(HeadCount),HeadCount[In/Out] = "Inflow")

-Outflow 

Code: Outflow = 0-CALCULATE(COUNTROWS(HeadCount),HeadCount[In/Out] = "Outflow")

Net movement

Code: Net Movement = 'MeasureFolder'[Inflow] -(0-('MeasureFolder'[Outflow]))

However, is there a way to see the specific names of the employees who left the company when i click on outflow in the chart? Can be a table or anything. This is because i have created a slicer and it shows me the list of employees who left the company, likewise for those who joined the company. Thanks. 

[Tahreem24]

@Anonymous Will it possible to share the dummy data for your requirement to understand your issue?

[Anonymous]

I cant send you the powerbi report, however, i can send you the dummy excel file. 

I have managed to configure by adding slicer and it gets the result i want. However, is there a way to just manually click it on the graph instead? Thanks.