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.