Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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 |
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