ERROR : Lookupvalue error: A table of multiple values was supplied where a single value was expected

[Medha12]

Hi,
I am creating a report where I need to display the current data and the previous data for a field (Consider
Report Number in this case)
I am able to display data for current report number.

For Previous report number, I created a calculated column :
Previous Report Number = LOOKUPVALUE(Table1[Report Number], Table1[Index],Table1[Index]-1)

Similarly, to display the data based on previous report number, I have created calculated columns for all
fields that needs to be displayed(Consider name in this case) using the DAX expression:
Previous_data = LOOKUPVALUE(Table2[Name], Table1[Index],Table1[Index]-1

The above expression changes according to the columns to be displayed
But I am getting an error "a table of multiple values was supplied where a single value was expected"
for some of the columns. For others, it is working fine.
Can someone please help me?

[v-yuta-msft]

Hi Medha12,

Have you created a relationship between the two tables? If you have, I recommend you to use related() function to express other table columns in lookupvalue() function so that the rows can match with each other in two tables.

In addtion, no matter if the relationship is one-many or many-two, related() function can be only used in the "one" side table.

Hope it's helpful to you.

Jimmy Tao

[Medha12]

Hi @v-yuta-msft

There is a Many to one relationship between the two tables.

Using related() function in the above DAX expression on the one side table gives an error -"Lookupvalue expects column reference as its argument"

Thanks