Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
40 | |
26 | |
22 | |
21 | |
16 |