https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225490#M118111 <P>Ho do i Fill Down?</P> Mon, 08 May 2023 18:25:41 GMT hagosusng 2023-05-08T18:25:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225420#M118103 <P>Hi,</P><P>&nbsp;</P><P>I want to convert all the NaN into the value of the previous row that have a non NaN value. Please can anyone help me.</P><P>&nbsp;</P><P><img /></P><P>I have looked uo the below link, but it wasn't helpful</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/Desktop/Power-Query-how-to-replace-null-with-previous-row-value/td-p/2717330" target="_blank">Solved: Power Query- how to replace null with previous row... - Microsoft Power BI Community</A></P><P>&nbsp;</P><P><SPAN>Thank you in advance&nbsp;</SPAN></P><P><img /></P><P>&nbsp;</P> Mon, 08 May 2023 17:32:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225420#M118103 hagosusng 2023-05-08T17:32:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225484#M118109 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="557326" data-lia-user-login="hagosusng" class="lia-mention lia-mention-user">hagosusng</a>&nbsp;</P> <P>you can <EM>Replace Values "</EM>NaN" with <EM>null</EM> then <EM>Fill Down</EM></P> Mon, 08 May 2023 18:16:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225484#M118109 tamerj1 2023-05-08T18:16:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225490#M118111 <P>Ho do i Fill Down?</P> Mon, 08 May 2023 18:25:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225490#M118111 hagosusng 2023-05-08T18:25:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225492#M118112 <P>I have the data in PowerBI</P> Mon, 08 May 2023 18:26:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225492#M118112 hagosusng 2023-05-08T18:26:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225539#M118121 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="557326" data-lia-user-login="hagosusng" class="lia-mention lia-mention-user">hagosusng</a>&nbsp;</P> <P>You need to do this data transformation using power query. Open the query editor as per the following screenshot&nbsp;</P> <P><img /></P> <P> Right click on the column that you want to perform transformation on and select "replace values" then right click again and select "fill" "down"</P> <P>&nbsp;</P> Mon, 08 May 2023 19:05:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-Nan-with-the-value-of-the-previous-non-NaN-row-in-the/m-p/3225539#M118121 tamerj1 2023-05-08T19:05:29Z