question

CarinMansfield-2636 avatar image
0 Votes"
CarinMansfield-2636 asked Lz-3068 answered

I am trying to work out the basic calculation of Fin Exp diff= C-(A+B)

Good day,

I am trying to work out the basic calculation of Fin Exp diff= C-(A+B)

C = 'Case Data'[Financial Exp]
A = 'Case Data'[Actual Loss]
B = 'Case Data'[Savings (Total)]

When applying the below query the amount is incorrect - It is showing the amount in 'Case Data'[Financial Exp] (C)

Fin Exp diff = 'Case Data'[Financial Exp]-(('Case Data'[Actual Loss])+ ('Case Data'[Savings (Total)]))

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered

Hi @CarinMansfield-2636

The following formula (unecessary parentheses removed) indicates this isn't a Power Query issue:

 = 'Case Data'[Financial Exp] - ('Case Data'[Actual Loss] + 'Case Data'[Savings (Total)])

However, it's not possible to determine if it's an Excel/Power Pivot or PowerBI issue

In Excel+Power Pivot or PowerBI the above formula should work. However
IF ('Case Data'[Actual Loss] + 'Case Data'[Savings (Total)]) = 0
THEN 'Case Data'[Financial Exp] - ('Case Data'[Actual Loss] + 'Case Data'[Savings (Total)]) = 'Case Data'[Financial Exp]

Assuming the issue isn't as simple as above, please provide additional information:
- Product in use
- Where the data come from
...

Idealy upload & share (i.e with OneDrive or any other file sharing service) an Excel workbook (if Excel/Power Pivot) or a .pbix (if PowerBI) where the issue can be seen/reproduced


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.