https://community.fabric.microsoft.com/t5/Dataflow/replace-null-in-columns-before-unpivoting/m-p/3575310#M1419 <P>The solution was to transpose the whole tabel I was unpivoting.&nbsp;</P><P>thanks&nbsp;</P> Sat, 09 Dec 2023 01:34:40 GMT JohnAG 2023-12-09T01:34:40Z https://community.fabric.microsoft.com/t5/Dataflow/replace-null-in-columns-before-unpivoting/m-p/3575138#M1418 <P>Hey guys,&nbsp;<BR />Can I fill the nulls across to the right and go one row down and get the month as well?<BR />see image below&nbsp;<BR /><img /></P><P><BR /><STRONG>Expected results</STRONG></P><P><img /></P><P>&nbsp;</P> Fri, 08 Dec 2023 20:52:09 GMT https://community.fabric.microsoft.com/t5/Dataflow/replace-null-in-columns-before-unpivoting/m-p/3575138#M1418 JohnAG 2023-12-08T20:52:09Z https://community.fabric.microsoft.com/t5/Dataflow/replace-null-in-columns-before-unpivoting/m-p/3575310#M1419 <P>The solution was to transpose the whole tabel I was unpivoting.&nbsp;</P><P>thanks&nbsp;</P> Sat, 09 Dec 2023 01:34:40 GMT https://community.fabric.microsoft.com/t5/Dataflow/replace-null-in-columns-before-unpivoting/m-p/3575310#M1419 JohnAG 2023-12-09T01:34:40Z