Forum Discussion
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...
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!
Thank you for the information. Would this be placed in conditional formatting or hardcoded in the editor function line of Power Query?
This would be a DAX measure.
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