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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ram_DCT
Helper II
Helper II

Cumulative Total as Calculated column in continuous date table

Hi,
I need to have a cumulative count of the hired employees [Hired-terminated] in a date table where we have continuous dates available and we should be able to filter the cumulative count by all the dimensions available in the below sample data.
Below is the sample data: I need to take avg. headcount and plot on the line chart and this chart should be filterable by all the possible dimensions in below sample data.

Employee_IDLegalIDWorker_LOBWorker_Customer_IDHire_DateTermination_DateJob_Family_Group
000958LE004LOB004C0051/22/2001 Customer Service Group
301123LE004LOB004C0051/10/2005 Customer Service Group
300029LE004LOB004C0059/26/2005 Customer Service Group
209392LE004LOB002C0026/28/20104/30/2020Sales Group
725275LE004LOB004C0039/27/2010 Sales Group
725283LE004LOB004C0059/27/2010 Customer Service Group
728624LE004LOB002C0026/20/20115/3/2020Sales Group
209855LE004LOB002C0029/19/2011 Sales Group
730567LE004LOB002C0029/19/2011 Sales Group
708177LE004LOB002C00212/2/2011 Sales Group
732951LE004LOB002C0022/24/20126/15/2020Sales Group
732962LE004LOB002C0022/24/2012 Sales Group
733671LE004LOB004C0014/11/2012 Sales Group
733628LE004LOB002C0024/16/2012 Sales Group
735690LE004LOB004C0037/16/2012 Sales Group
735690LE004LOB004C0037/16/2012 Sales Group
735690LE004LOB004C0037/16/2012 Sales Group
735690LE004LOB004C0037/16/2012 Sales Group
735690LE004LOB004C0037/16/2012 Sales Group
736792LE004LOB002C00210/19/20121/1/2020Sales Group
737580LE004LOB002C0021/7/2013 Sales Group
766660LE004LOB002C0022/4/2013 Sales Group
739488LE004LOB002C0023/1/2013 Sales Group
734469LE004LOB002C0023/1/2013 Sales Group
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.