I am banging my head against the wall here.
I have this measure:
If((SUM(Query1[BalanceSaldo]))=BLANK();0;SUM(Query1[BalanceSaldo]))
I have also tried:
If(ISBLANK(SUM(Query1[BalanceSaldo]));0;SUM(Query1[BalanceSaldo]))
but with no avail - neither of the measures is replacing blanks with zeros.
The measure SUM() is basically summing up balances in financial accounts. In the Power Pivot table I have account names and categories showing in the rows and fiscal periods (2019 and 2020) showing on the columns.
My goal with this measure is to make the Pivot Table show 0 for year 2019 column in case there is only balance for a given row in 2020 and not in 2019... and vice versa.
I would use this measure further to give me differences between year columns (i noticed it does not make calculations when the other column is blank so that is why I am aiming for the zero value to fill in the blanks for me).
Thank you in advance!
