Power Query Updating a row

[vishal140197]

I am trying to do this in Power BI. Whether DAX or Power Query anything would be useful.

I have 2 columns one is 'Date' and the other is 'Version Number'.

I want to update the dates where 'Version Number' is Version_1 and 'Date' is blank to the dates where 'Version Number' is Version_2 and 'Date' is not blank.

Basically if Version_2 has a date and Version_1 doesn't have a date then the dates of these Version_2 should be copied to Version_1 dates.

Tried nested ifs in power query and DAX but not able to achieve the desired result.

[ChiragGarg2512]

@vishal140197 share a sample data in tabular form.

[vishal140197]

Project Number	Date	Version Number
1234		Version_1
12345	01/01/2021	Version_1
1234		Version_1
1234	20/11/2022	Version_2
1234	20/11/2022	Version_2
1234	20/11/2022	Version_2
1234		Version_1
1234	21/11/2022	Version_3
1234	21/11/2022	Version_5
12345	21/11/2022	Version_2
1234	21/11/2022	Version_4

[AlienSx]

@vishal140197 

let
    Source = your_table,
    fx_v2_date = (tbl as table) as table =>
        [v2_date = Table.SelectRows(tbl, each [Version Number] = "Version_2"){0}[Date]?,
        v1_change = 
            Table.ReplaceValue(
                tbl, each [Version Number], v2_date, 
                (v, o, n) => 
                    if v = null and o = "Version_1" 
                    then n else v, {"Date"}
            )][v1_change],
    group = 
        Table.Group(
            Source, {"Project Number"}, 
            {{"all", fx_v2_date}}
        ),
    expand = Table.ExpandTableColumn(group, "all", {"Date", "Version Number"})
in
    expand