Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper III
6 years ago

Number at a particular date

Hi,   I have the following data on headcount.   Name Position Start Date End Date Current Status Joe Bloggsd Head of Marketing 21/02/2017   Established Noah Anyone Head of Opera...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tobiasmcbride 

 

In the attached file, I've added myself as an extra record, as you can see I'm still aspiring in the slicer however you will not be able to see me in the headcount by date because it would not make a logical sense.

 

If you need to count this individual separately, you can create another measure like below.

Headcount no start date = 
CALCULATE(
    COUNTROWS( employee ),
    ISBLANK( employee[Start Date] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tobiasmcbride 

 

Another way would be selecting a date point in the future by replacing start date nulls with let's say today + 30 and allocating this individual there.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn