The following measure produces a different result depending on whether I use a machine with Excel 2013 or Excel 2016:
=FIRSTNONBLANK(Russell_Group[Provider short name],
IF( [Research Income (Total) £k] =
CALCULATE([Benchmark (Research Income £k)],
VALUES( Russell_Group[Provider short name])
),
1,
BLANK()
)
)
In Excel 2013 it produces the correct result, by returning the correct "Provider Short Name" (where their Research Income (Total) £k is equal to the Benchmark (Research Income £k))
In Excel 2016, the measure does not work correctly, and instead returns the first "Provider Short Name" in the Russel_Group table.
Any insight on why the resuts are different would be much appreciated!
=FIRSTNONBLANK(Russell_Group[Provider short name],
IF( [Research Income (Total) £k] =
CALCULATE([Benchmark (Research Income £k)],
VALUES( Russell_Group[Provider short name])
),
1,
BLANK()
)
)
In Excel 2013 it produces the correct result, by returning the correct "Provider Short Name" (where their Research Income (Total) £k is equal to the Benchmark (Research Income £k))
In Excel 2016, the measure does not work correctly, and instead returns the first "Provider Short Name" in the Russel_Group table.
Any insight on why the resuts are different would be much appreciated!
Last edited:
