Can not use expressions that return the variant data type to define computed columns.

[larabraghetti]

Hi!!!

I have a new issue and I think you can help me!

In the table "Anag" I have an imported column called "Effective Duration" that contains decimal numbers. Here the column:

Then I have another table called Trasc Scadenze:

In the table Anag I created a calculated column:

ED = LOOKUPVALUE('Trasc Scandenze'[Range Scadenza];'Trasc Scandenze'[Scadenza];ROUND(Anag[Effective Duration];1))

The issue is that it seems that the lookupvalue doesn't work for all the rows:

I don't undestand why it works only for some rows.
Any idea?
Thank you in advance!
Lara

[v-sihou-msft]

@larabraghetti

In this secnario, when using LOOKUPVALUE(), it shows BLANK() when mismatching rows. So it seems something makes 'Trasc Scandenze'[Scadenza] not equal to ROUND(Anag[Effective Duration],1). Since the format of two column looks like same, please try to remove the ROUND() function to see if the LOOKUPVALUE works properly. If the issue still persists, please share your PBIX. As I test in my local envionment (Power BI Desktop with April Update), it works fine.

Regards,

[larabraghetti]

Thank you @v-sihou-msft!

I have tried but without success.

How can I send you here the .pbix file.

Is it enough share the dashboard?

I'm using this version of PowerBI: Versione: 2.34.4372.501 64-bit (april 2016)

[larabraghetti · Accepted solution]

@v-sihou-msft

Hi! I've found the solution!

I used the Conditional Column in order to define the range of years!
Thank you
Lara

[larabraghetti]

Any idea?