Forum Discussion
Average Employee Count
Hi All! First time PBI user. I have a report that contains Employee Names, Unique ID, Hire Date, Termination Date and Status (Active, Terminated). My goal is to calculate monthly, quarterly and yearly...
Hi,
Share a dataset and show the expected result.
Ashish, thanks for the reply. Here are some screenshots of what I do in Excel and I am trying to translate it to Power BI. There are the exact files I am connecting to.
Screenshot of what I use to calculate average employees
Screenshot of my Terminations List
And finally, the summary page of my results as they appear in Excel (Would use a combo of tables and visuals in Power BI)
Hi,
I cannot understand anything from those screenshots. I will need to see that Excel file.