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 but not the date. Date's value I want to copy from other column.

Below tables will give the idea of my problem and the output I need.

And the output table I need is as below-

 Can someone please help me with this?

 

 

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

3 Replies

  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper 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.