topic How to fill the blank with the same value as the first row in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-fill-the-blank-with-the-same-value-as-the-first-row/m-p/3293207#M122627 <P>Dear Experts, would like to check how should i fill up the blank in Team Name that read the same value as the first.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Team Name</TD><TD>Agent Name</TD></TR><TR><TD>Team A</TD><TD>A</TD></TR><TR><TD>&nbsp;</TD><TD>B</TD></TR><TR><TD>Team B</TD><TD>C</TD></TR><TR><TD>&nbsp;</TD><TD>D</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD></TR><TR><TD>&nbsp;</TD><TD>F</TD></TR><TR><TD>Team C</TD><TD>G</TD></TR><TR><TD>&nbsp;</TD><TD>H</TD></TR><TR><TD>&nbsp;</TD><TD>I</TD></TR><TR><TD>&nbsp;</TD><TD>J</TD></TR><TR><TD>&nbsp;</TD><TD>K</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>end result should be as below.&nbsp;</P><TABLE><TBODY><TR><TD>Team Name</TD><TD>Agent Name</TD></TR><TR><TD>Team A</TD><TD>A</TD></TR><TR><TD>Team A</TD><TD>B</TD></TR><TR><TD>Team B</TD><TD>C</TD></TR><TR><TD>Team B</TD><TD>D</TD></TR><TR><TD>Team B</TD><TD>E</TD></TR><TR><TD>Team B</TD><TD>F</TD></TR><TR><TD>Team C</TD><TD>G</TD></TR><TR><TD>Team C</TD><TD>H</TD></TR><TR><TD>Team C</TD><TD>I</TD></TR><TR><TD>Team C</TD><TD>J</TD></TR><TR><TD>Team C</TD><TD>K</TD></TR></TBODY></TABLE> Tue, 20 Jun 2023 12:30:11 GMT AAAbbbnewbie 2023-06-20T12:30:11Z How to fill the blank with the same value as the first row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-fill-the-blank-with-the-same-value-as-the-first-row/m-p/3293207#M122627 <P>Dear Experts, would like to check how should i fill up the blank in Team Name that read the same value as the first.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Team Name</TD><TD>Agent Name</TD></TR><TR><TD>Team A</TD><TD>A</TD></TR><TR><TD>&nbsp;</TD><TD>B</TD></TR><TR><TD>Team B</TD><TD>C</TD></TR><TR><TD>&nbsp;</TD><TD>D</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD></TR><TR><TD>&nbsp;</TD><TD>F</TD></TR><TR><TD>Team C</TD><TD>G</TD></TR><TR><TD>&nbsp;</TD><TD>H</TD></TR><TR><TD>&nbsp;</TD><TD>I</TD></TR><TR><TD>&nbsp;</TD><TD>J</TD></TR><TR><TD>&nbsp;</TD><TD>K</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>end result should be as below.&nbsp;</P><TABLE><TBODY><TR><TD>Team Name</TD><TD>Agent Name</TD></TR><TR><TD>Team A</TD><TD>A</TD></TR><TR><TD>Team A</TD><TD>B</TD></TR><TR><TD>Team B</TD><TD>C</TD></TR><TR><TD>Team B</TD><TD>D</TD></TR><TR><TD>Team B</TD><TD>E</TD></TR><TR><TD>Team B</TD><TD>F</TD></TR><TR><TD>Team C</TD><TD>G</TD></TR><TR><TD>Team C</TD><TD>H</TD></TR><TR><TD>Team C</TD><TD>I</TD></TR><TR><TD>Team C</TD><TD>J</TD></TR><TR><TD>Team C</TD><TD>K</TD></TR></TBODY></TABLE> Tue, 20 Jun 2023 12:30:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-fill-the-blank-with-the-same-value-as-the-first-row/m-p/3293207#M122627 AAAbbbnewbie 2023-06-20T12:30:11Z Re: How to fill the blank with the same value as the first row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-fill-the-blank-with-the-same-value-as-the-first-row/m-p/3293237#M122631 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="567243" data-lia-user-login="AAAbbbnewbie" class="lia-mention lia-mention-user">AAAbbbnewbie</a>,</P><P>In PowerQuery you can right click on the column and choose Fill -&gt; Down.</P><P><img /></P><P>&nbsp;</P><P><STRONG><FONT size="2">Best Regards, </FONT></STRONG></P><P><STRONG><FONT size="2">Alexander</FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@powerbi-vlog" target="_blank">My YouTube vlog in English</A></FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@pbi-vlog" target="_blank">My YouTube vlog in Russian</A></FONT></STRONG></P> Tue, 20 Jun 2023 12:45:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-fill-the-blank-with-the-same-value-as-the-first-row/m-p/3293237#M122631 barritown 2023-06-20T12:45:01Z