Forum Discussion

Frequent Visitor

3 years ago

Solved

Create Headcount Table based on Start and End Date

Hi there, I'm struggling with a key element of a report for my HR group. I have a data set ('Attrition Report') which contains two key columns, [Start Date] and [End Date]. I order to create ...

Need Help

dom-mitchell
3 years ago
I finally managed to find a solution and after multiple attempts at it not working (I had a tiny syntax error in my Dax), I managed to get the tips in this YouTube video to work for me:

Power BI Abstract Thesis Episode 65: Average of Rolling, Average of Snapshots - YouTube

Thanks to amitchandak and the link over at Solved: calculate average headcount & attrition - Microsoft Power BI Community

dom-mitchell

Frequent Visitor

3 years ago

I finally managed to find a solution and after multiple attempts at it not working (I had a tiny syntax error in my Dax), I managed to get the tips in this YouTube video to work for me:

Power BI Abstract Thesis Episode 65: Average of Rolling, Average of Snapshots - YouTube

Thanks to amitchandak and the link over at Solved: calculate average headcount & attrition - Microsoft Power BI Community

Forum Discussion

Create Headcount Table based on Start and End Date

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Headcount, Joiners, leavers and Mobility of employees.