topic Replacing NaN with 0 in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/758268#M3102 <P>Hello,</P><P>I'm looking for a way using DAX function to replace all the NaN values in my data to 0. (<SPAN>I do not have the original data file so that I cannot use query editor.)</SPAN></P><P>Thanks!</P> Mon, 05 Aug 2019 21:33:43 GMT zilaifeng 2019-08-05T21:33:43Z Replacing NaN with 0 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/758268#M3102 <P>Hello,</P><P>I'm looking for a way using DAX function to replace all the NaN values in my data to 0. (<SPAN>I do not have the original data file so that I cannot use query editor.)</SPAN></P><P>Thanks!</P> Mon, 05 Aug 2019 21:33:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/758268#M3102 zilaifeng 2019-08-05T21:33:43Z Re: Replacing NaN with 0 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/758651#M3105 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="159040" data-lia-user-login="zilaifeng" class="lia-mention lia-mention-user">zilaifeng</a>&nbsp;</P><P>&nbsp;</P><P>You can use if error like below.</P><P>&nbsp;</P><PRE>Column = IFERROR('Table'[Custom], BLANK())</PRE><P>&nbsp;</P><DIV>Best Regards,<BR />Mariusz<BR /><BR />If this post <STRONG>helps</STRONG>, then please consider <STRONG><I>Accepting it as the solution</I></STRONG>.<BR /><BR />Please feel free to connect with me.<BR /><A href="https://www.linkedin.com/in/mariusz-repczynski-065a7362/" rel="nofollow noopener noreferrer" target="_blank"><IMG src="https://ip1.i.lithium.com/1232d707bb27fc4afa3b81cd0702c478b6f7aced/68747470733a2f2f7374617469632e6c6963646e2e636f6d2f736364732f636f6d6d6f6e2f752f696d616765732f6c6f676f732f6c696e6b6564696e2f6c6f676f5f6c696e6b6564696e5f39337832315f76322e706e67" border="0" alt="Mariusz Repczynski" /></A></DIV><P>&nbsp;</P> Tue, 06 Aug 2019 07:30:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/758651#M3105 Mariusz 2019-08-06T07:30:17Z Re: Replacing NaN with 0 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/1849895#M39519 <P>Thanks for the quick solution.</P> Wed, 19 May 2021 01:54:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replacing-NaN-with-0/m-p/1849895#M39519 Anonymous 2021-05-19T01:54:05Z