I have multiple spreadsheets loading in to a Power Query, then back to Excel for Power Pivots. The attached is a small sample. I want my pivot table to show as follows; Rows will show Year, Column 1 - count of individual employees each year, Column 2 a count of how many employees started that year. Column 1 is easy enough using Distinct Count. Column 2 should show 1 for 2013, 2015 and 2016, 0 for the other years. I imagine there is a Measure (or two) that can be written for this, but I can't figure it out. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Pivot - Countif
- Thread starter scojax22
- Start date
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,235
- Office Version
- 365
- Platform
- Windows
- MacOS
Welcome to the MrExcel Message Board!
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Power Pivot - Countif - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Power Pivot - Countif - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Upvote
0
