Replace data according to the date

[Faisal Yunianto]

Hello guys, I had some power query case. I had dataset that contains a lot of rows and columns. For sample, in the table there is date and outlet user. I want to replace outlet user data according to the date that I want.

Example: in one column the outlet user are System Testing, Owner, etc. The date starts from first March, the outlet user is DANIEL. And then on March 7 the outlet user is NATHAN. And so on.

What I want is when the data start first March until March 6 the outlet user will replace into NATHAN. Start March 7 until the end of the data will replace into NATHAN.

I want to do dynamically in power query, because I can freely to change the name by needs. I appreciate who can solve this case. Thanks!

Note: actually there are thousands of data and dozens of files, so I using power query to make my work easier.

 

[Faisal Yunianto]

Sorry i forgot to post the sample data.

 

[GraH]

Where would be the logic of replacements?
In a table?
What's the logic behind your line

according to the date that I want.

 

[Faisal Yunianto]

Where would be the logic of replacements?
In a table?
What's the logic behind your line

I imagine have table replacements like this, so i can dynamically control and input another date and user

 

[GraH]

One easy way (100% UI-like)

let
    Source = Table.NestedJoin(Data, {"Date"}, replacements, {"Date"}, "replacements", JoinKind.LeftOuter),
    #"Expanded replacements" = Table.ExpandTableColumn(Source, "replacements", {"Outlet User"}, {"Outlet User.1"}),
    #"Filled Down" = Table.FillDown(#"Expanded replacements",{"Outlet User.1"})
in
    #"Filled Down"

 

[Faisal Yunianto]

One easy way (100% UI-like)

let
    Source = Table.NestedJoin(Data, {"Date"}, replacements, {"Date"}, "replacements", JoinKind.LeftOuter),
    #"Expanded replacements" = Table.ExpandTableColumn(Source, "replacements", {"Outlet User"}, {"Outlet User.1"}),
    #"Filled Down" = Table.FillDown(#"Expanded replacements",{"Outlet User.1"})
in
    #"Filled Down"

Thanks Bro, it works!