Forum Discussion

AnushaK's avatar
AnushaK
Regular Visitor
2 years ago
Solved

Need help with the Power Query

Hi Everyone,   I have just started to work on Power BI. I am stuck currently. In the table, if there is a null value for a row, I want to create new rows and copy previous date's data in the rows ...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
    let
    Source = your_table,
    group = Table.Group(
        Source, "DateRange",
        {{"x", (x) => if x[Date]{0} = null then null else x},
        {"Date", (x) => if x[Date]{0} = null then x[DateRange]{0} else x[Date]{0}}}
    ),
    down = Table.FillDown(group, {"x"}),
    xpand = Table.ExpandTableColumn(down, "x", {"Transactions"})
in
    xpand
AlienSx's avatar
AlienSx
Super User
2 years ago
let
    Source = your_table,
    group = Table.Group(
        Source, "DateRange",
        {{"x", (x) => if x[Date]{0} = null then null else x},
        {"Date", (x) => if x[Date]{0} = null then x[DateRange]{0} else x[Date]{0}}}
    ),
    down = Table.FillDown(group, {"x"}),
    xpand = Table.ExpandTableColumn(down, "x", {"Transactions"})
in
    xpand
AnushaK's avatar
AnushaK
Regular Visitor
2 years ago

Thank you so much AlienSx . Will try this. But I need to add rows as well. Number of rows to be added depends on number of transactions present for the previous date.