Forum Discussion
Subtracting Null/Blank values between 2 columns
Thank you Nolock, I figured it out finally. My calculated columns for the net difference were "backwards". I had to create the calc column in the summary table; instead of in the D365 table.
Mike
Hi mhammo_aka,
I've checked your formulas and they seem ok, but then I saw there is something suspicious.
I changed your formula just to ROAR-D365 Net Diff = 42 and I got the same problem. Blanks at the beginning and the value 42 later. It took me to the Relationships view of PowerBI where I saw that you have a relation between 2 tables: D365 and Summary Transactions.
It seems (at least to me) like you have 2 fact tables which you want to join. And you do that in both directions. If I change the direction from one-to-one with both directions to something else, your report stops working.
Please check your data model, if it does what you expect.
Thank you Nolock, I figured it out finally. My calculated columns for the net difference were "backwards". I had to create the calc column in the summary table; instead of in the D365 table.
Mike
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.
