Filling Up Based on Other Column Value

[Anonymous]

Could someone advise please how to perform the following transformation, I want to fill up Column: Resigned till the value of Column: Name changes, meaning, I want to fill up for all the cells related to: Second Person, and stop when the value of Column: Name becomes: First Person, how could I do that?

[edhans]

You are going to have to give us information.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[Anonymous]

I've tried to upload a photo for the data but it didn't allow me

But here you go, please find the table

[Jakinta]

Group by Name column >

FillUp Resigned column in nested table >

Expand

[Anonymous]

By applying this, the fill up will go for instance for HR ID 2499, which is valid) but for 2498 and 2497 as well which is invalid.

[Jakinta]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUVKK1cHGMEJmRKYWg9nGMEFMhglWBlhjLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Resigned = _t]),
    Nulls = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Resigned"}),
    Grouped = Table.Group(Nulls, {"Name"}, {{"Gr", each Table.FillUp(_,{"Resigned"}), type table [Name=nullable text, Resigned=nullable text]}}),
    Expanded = Table.ExpandTableColumn(Grouped, "Gr", {"Resigned"}, {"Resigned"})
in
    Expanded

[Anonymous]

Ok, wait, I think I managed to manipulate the script to match my columns headings, but I'm afraid I'm still getting an error

[Jakinta]

You have to add hashtag in front of column names with spaces.

#"HR ID" 

#"Resigned / Promoted"

[Anonymous]

Nope, it doesn't work,  even for simplicy I made the headings of one single word to avoid the confusion of adding / not adding #, but it seems that the issue with something else

[Jakinta · Accepted solution]

You have dash in 2nd argument of Table.FillUp. It should be removed...

You were not encouraged to do that with my code. 🙂

[Anonymous]

You are so good, it works perfectly, thanks a million.

[Anonymous]

You are so good, it works perfectly, thanks a million.

[Anonymous]

I'm so sorry, it seems that I cannot comprehend the script really, could you show me a screenshot of Group By step? Something like that

[Anonymous]