Forum Discussion

Koli's avatar
Koli
Frequent Visitor
2 years ago
Solved

Reconciling 2 Data Sets

Hello,   I hope all is well. I am trying to reconcile 2 different data sets. One of the problems I am running to is rounding and conditional formatting. For example: Sum of Amount          2nd Am...
Need Help
  • Koli's avatar
    Koli
    2 years ago

    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!

lbendlin's avatar
lbendlin
Super User
2 years ago

you are missing the "and" part of the rule, the Power Query equivalent for the DAX "&&".

Koli's avatar
Koli
Frequent Visitor
2 years ago

Hello,

 

Thank you again for your assistance. I am still receiving and error message. I really don't know what I am doing wrong.🤔

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Power Query mandates the use of the "else"  branch.

    • Koli's avatar
      Koli
      Frequent Visitor
      2 years ago

      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.