topic Fill Missing Value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fill-Missing-Value/m-p/3387308#M127656 <P>Hello everybody,</P><P>I'm discovering DAX language and I have some difficulties to do thant I want.</P><P>I will explain you my issue.</P><P>&nbsp;</P><P>in the field "Prodline", I don't have always value, I have only one when "MvtType" is 101.</P><P>I would like to complete Field "Prodline" when data is missing and take data when "ProdOrder" is same</P><P>&nbsp;</P><P>I tried to mix together function IF and LookUpValue but It's not working</P><P>&nbsp;</P><P>You can find an extract of my table below</P><P>&nbsp;</P><P>Thanks you a lot.</P><P>&nbsp;</P><P>Regards&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>table [Trial_Table]</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>ProdOrder</TD><TD>ItemCode</TD><TD>MaterialDoc</TD><TD>MvtType</TD><TD>Qty</TD><TD>Unit</TD><TD>Batch</TD><TD>RemQty</TD><TD>ProdLine</TD><TD>Date</TD><TD>ProdLine (groupes)</TD><TD>Qty Corrigé</TD><TD>New Prodline</TD></TR><TR><TD>150954</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029705832</TD><TD>101</TD><TD>2400</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 06:38</TD><TD>50 - PER</TD><TD>2400</TD><TD>&nbsp;</TD></TR><TR><TD>151079</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029707684</TD><TD>101</TD><TD>2134</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 11:28</TD><TD>50 - PER</TD><TD>2134</TD><TD>&nbsp;</TD></TR><TR><TD>151148</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029708094</TD><TD>101</TD><TD>2133</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 13:43</TD><TD>50 - PER</TD><TD>2133</TD><TD>&nbsp;</TD></TR><TR><TD>151078</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029707682</TD><TD>102</TD><TD>2400</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 11:28</TD><TD>(Vide)</TD><TD>-2400</TD><TD>&nbsp;</TD></TR><TR><TD>151147</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029708092</TD><TD>102</TD><TD>2134</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 13:42</TD><TD>(Vide)</TD><TD>-2134</TD><TD>&nbsp;</TD></TR><TR><TD>150716</TD><TD>100005820042</TD><TD>ZZ70496221-05XM</TD><TD>6029703776</TD><TD>101</TD><TD>2146</TD><TD>PC</TD><TD>0017964849</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 00:18</TD><TD>50 - PER</TD><TD>2146</TD><TD>&nbsp;</TD></TR><TR><TD>151216</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708611</TD><TD>101</TD><TD>2284</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 16:43</TD><TD>50 - PER</TD><TD>2284</TD><TD>&nbsp;</TD></TR><TR><TD>151219</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708626</TD><TD>101</TD><TD>2283</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 16:48</TD><TD>50 - PER</TD><TD>2283</TD><TD>&nbsp;</TD></TR><TR><TD>151217</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708622</TD><TD>102</TD><TD>2284</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 16:48</TD><TD>(Vide)</TD><TD>-2284</TD><TD>&nbsp;</TD></TR><TR><TD>150992</TD><TD>100005820044</TD><TD>ZZ70496221-05XM</TD><TD>6029706124</TD><TD>101</TD><TD>2222</TD><TD>PC</TD><TD>0017964851</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 07:18</TD><TD>50 - PER</TD><TD>2222</TD><TD>&nbsp;</TD></TR><TR><TD>151456</TD><TD>100005820047</TD><TD>ZZ70496221-05XM</TD><TD>6029709342</TD><TD>101</TD><TD>2214</TD><TD>PC</TD><TD>0017964854</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 23:24</TD><TD>50 - PER</TD><TD>2214</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 18 Aug 2023 12:04:05 GMT What3lse 2023-08-18T12:04:05Z Fill Missing Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fill-Missing-Value/m-p/3387308#M127656 <P>Hello everybody,</P><P>I'm discovering DAX language and I have some difficulties to do thant I want.</P><P>I will explain you my issue.</P><P>&nbsp;</P><P>in the field "Prodline", I don't have always value, I have only one when "MvtType" is 101.</P><P>I would like to complete Field "Prodline" when data is missing and take data when "ProdOrder" is same</P><P>&nbsp;</P><P>I tried to mix together function IF and LookUpValue but It's not working</P><P>&nbsp;</P><P>You can find an extract of my table below</P><P>&nbsp;</P><P>Thanks you a lot.</P><P>&nbsp;</P><P>Regards&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>table [Trial_Table]</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>ProdOrder</TD><TD>ItemCode</TD><TD>MaterialDoc</TD><TD>MvtType</TD><TD>Qty</TD><TD>Unit</TD><TD>Batch</TD><TD>RemQty</TD><TD>ProdLine</TD><TD>Date</TD><TD>ProdLine (groupes)</TD><TD>Qty Corrigé</TD><TD>New Prodline</TD></TR><TR><TD>150954</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029705832</TD><TD>101</TD><TD>2400</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 06:38</TD><TD>50 - PER</TD><TD>2400</TD><TD>&nbsp;</TD></TR><TR><TD>151079</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029707684</TD><TD>101</TD><TD>2134</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 11:28</TD><TD>50 - PER</TD><TD>2134</TD><TD>&nbsp;</TD></TR><TR><TD>151148</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029708094</TD><TD>101</TD><TD>2133</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 13:43</TD><TD>50 - PER</TD><TD>2133</TD><TD>&nbsp;</TD></TR><TR><TD>151078</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029707682</TD><TD>102</TD><TD>2400</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 11:28</TD><TD>(Vide)</TD><TD>-2400</TD><TD>&nbsp;</TD></TR><TR><TD>151147</TD><TD>100005820041</TD><TD>ZZ70496221-05XM</TD><TD>6029708092</TD><TD>102</TD><TD>2134</TD><TD>PC</TD><TD>0017964847</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 13:42</TD><TD>(Vide)</TD><TD>-2134</TD><TD>&nbsp;</TD></TR><TR><TD>150716</TD><TD>100005820042</TD><TD>ZZ70496221-05XM</TD><TD>6029703776</TD><TD>101</TD><TD>2146</TD><TD>PC</TD><TD>0017964849</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 00:18</TD><TD>50 - PER</TD><TD>2146</TD><TD>&nbsp;</TD></TR><TR><TD>151216</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708611</TD><TD>101</TD><TD>2284</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 16:43</TD><TD>50 - PER</TD><TD>2284</TD><TD>&nbsp;</TD></TR><TR><TD>151219</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708626</TD><TD>101</TD><TD>2283</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 16:48</TD><TD>50 - PER</TD><TD>2283</TD><TD>&nbsp;</TD></TR><TR><TD>151217</TD><TD>100005820043</TD><TD>ZZ70496221-05XM</TD><TD>6029708622</TD><TD>102</TD><TD>2284</TD><TD>PC</TD><TD>0017964850</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17/08/2023 16:48</TD><TD>(Vide)</TD><TD>-2284</TD><TD>&nbsp;</TD></TR><TR><TD>150992</TD><TD>100005820044</TD><TD>ZZ70496221-05XM</TD><TD>6029706124</TD><TD>101</TD><TD>2222</TD><TD>PC</TD><TD>0017964851</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 07:18</TD><TD>50 - PER</TD><TD>2222</TD><TD>&nbsp;</TD></TR><TR><TD>151456</TD><TD>100005820047</TD><TD>ZZ70496221-05XM</TD><TD>6029709342</TD><TD>101</TD><TD>2214</TD><TD>PC</TD><TD>0017964854</TD><TD>&nbsp;</TD><TD>PER</TD><TD>17/08/2023 23:24</TD><TD>50 - PER</TD><TD>2214</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 18 Aug 2023 12:04:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fill-Missing-Value/m-p/3387308#M127656 What3lse 2023-08-18T12:04:05Z Re: Fill Missing Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fill-Missing-Value/m-p/3389776#M127772 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="605007" data-lia-user-login="What3lse" class="lia-mention lia-mention-user">What3lse</a>,</P><P>If I correctly understand the logic for filling missing values, you could use a calculated column like this:</P><P><img /></P><P>In plain text for convenience:</P><LI-CODE lang="markup">ProdLine Updated = IF ( NOT ISBLANK ( [ProdLine] ), [ProdLine], VAR CurrentProdOrder = [ProdOrder] VAR Result = MAXX ( FILTER ( Data, [ProdOrder] = CurrentProdOrder ), [ProdLine] ) RETURN Result )</LI-CODE><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><P>&nbsp;</P> Mon, 21 Aug 2023 09:45:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fill-Missing-Value/m-p/3389776#M127772 barritown 2023-08-21T09:45:59Z