Forum Discussion

Decal's avatar
Decal
Icon for Helper I rankHelper I
2 years ago
Solved

URGENT: Single Cell Date Replace

I'm doing HR reporting where Hire Date is an important field.     A person was rehired under the same employee ID causing retention reporting to be thrown off.   The employee id is 07385.  The cu...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago
    #"HireDtKaylee" = Table.ReplaceValue(
        #"Replaced Value2",
         each [EEID] = "07385",
         #date(2020,9,8),
         (x,y,z)=> if y = true then z else x,
         {"Hire Date"})
ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
2 years ago
#"HireDtKaylee" = Table.ReplaceValue(
        #"Replaced Value2",
         each [EEID] = "07385",
         #date(2020,9,8),
         (x,y,z)=> if y = true then z else x,
         {"Hire Date"})
Decal's avatar
Decal
Icon for Helper I rankHelper I
2 years ago

I'm unclear how to use the x,y,z.  Can you clarify how to use the eeid and dates in here?