Need help with the Power Query

[AnushaK]

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?

[AlienSx · Accepted solution]

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]

Got it! It's working fine!! Thank you so so much @AlienSx 

[AnushaK]

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.