How to see totals on a visual?

[yulia1906]

Hello Community! I am building the HR dashboard and need to show the trend of the total headcount. The visual is showing the new employees that were joining the company, but not the total headcount change over the time (January + February + March, etc). How can I build that?

[Ashish_Mathur]

Hi,

The solution will depend on the data setup.  Share data in a format the can be pasted in an MS Excel file.

[olgad]

Hi, first calculate your headcount measure, people with the start date before or in a particular month and end date after a particular month/date.
then create a cumulative using that measure

Cumulative Total =
CALCULATE (
Headcountmeasure,
FILTER (
ALL( 'CalendarTable'[Date] ),
'Calendar Table'[Date] <= MAX ( 'CalendarTable'[Date Date] )
)
)