<div>
<div class="content wysiwyg-content">
What is the proper syntax (DAX) to compare two values and if there is a difference then return the newer value.<br />
<br />
Similar to an Index Match. I am using Power Query to create a Pivot Table that will display the current value if match with new value and the new value if there is a difference.<br />
<br />
=if (OrgNoA &lt;&gt;OrgNoB, then OrgNoB else OrgNoA.<br />
<br />
This has to be in Power Query.<br />
<br />
Thanks,<br />
<br />
Karen
</div>
</div>


What is the proper syntax (DAX) to compare two values and if there is a difference then return the newer value.

Similar to an Index Match. I am using Power Query to create a Pivot Table that will display the current value if match with new value and the new value if there is a difference.

=if (OrgNoA <>OrgNoB, then OrgNoB else OrgNoA.

This has to be in Power Query.

Thanks,

Karen

Excel Power Query - compare 2 values and return the new value if there is a difference

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.