Forum Discussion
Changes Between Reports - Complexity Management
Hi Anonymous ,
Will attach Pbix in a couple. The crux was selecting the second month, and creating new table from the merge, and using anti. This is all in Power Query so should be fully auto.
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
let
Source = Table.NestedJoin(September, {"Emp"}, August, {"Emp"}, "August", JoinKind.RightAnti),
#"Expanded August" = Table.ExpandTableColumn(Source, "August", {"Emp", "ID"}, {"August.Emp", "August.ID"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded August",{"Emp", "ID"})
in
#"Removed Columns"- Nathaniel_C6 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- Anonymous6 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!