Forum Discussion
Reconciling 2 Data Sets
Hello,
Thank you for responding. I was able to figure it out. I used conditional formatting,
if AF variance is less than or equal to zero then rounding.
Thank you!
Hello,
Thank you for the information. I looked up DAX usage in Power Query , however, when I went to try to add the query to a data model, I received error message memory. I have 32 bit excel. Here is a picture of one of the errors. I am loaded as connection only
 
you are missing the "and" part of the rule, the Power Query equivalent for the DAX "&&".
Hello,
Thank you again for your assistance. I am still receiving and error message. I really don't know what I am doing wrong.🤔
Power Query mandates the use of the "else" branch.
Hello,
Thank you again for the quick response! Unfortunately, this is not working. I am sure this is user error. When I put in the formula it doesn't bring back the desired results as seen in the initial example.
Could you please help in writing the formula out using the fields on the previous screenshot in power query, so that I can see what I am doing wrong? I am a newbie to power query. Thank you in advance!
For example:
Sum of Amount 2nd Amount
$130.00 $129.99998
Essentially these are the same numbers with rounding
I would like the conditional formatting to read .. if sum of amount is almost the sum of the 2nd amt then place remark, else null.