Forum Discussion
Anonymous
6 years agoNot applicable
Changes Between Reports - Complexity Management
Hello Everyone, Here is the challenge I am facing. I have one headcount report (*xlsx) every month. Exactly the same columns, thousands of rows. What is the goal? 1. Compare records between...
Nathaniel_C
6 years agoCommunity Champion
Hi Anonymous ,
Here is the PBIX Hires and Fires
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Anonymous
6 years agoNot applicable
Nathaniel_C - thank you for your help!
I am just wondering now... once I get October data (*xlsx), is there a smart way (automation) that will automatically create four new tables with:
* October New Hires (vs August and vs Sep)
* October New Fires (vs August and vs Sep)
Or do I need to manually create queries and adjust the M code?
thank you once again!