Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am having some issues trying to pivot and unpivot and getting confused.
I have hire, fire, re-hire and re-fire dates and I want to combine the hires and fires into one column and simply duplicate the ID
@ARomain , Assume your table name is Table 1
Try this in a new blank query in power query
let
source = Table.Combine({
Table.SelectColumns(Table1,{"Name", "Hire", "Fire"}),
Table.RenameColumns(
Table.SelectColumns(Table1,{"Name", "Re-Hire", "Re-Fire"}),
{{"Re-Hire", "Hire"},{"Re-Fire", "Fire"}}
)
)
in
source
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |