Error while using lookup.

[Satish_Kumar]

Hi All,

I need help in this issue which I am facing.

I am trying to use a column for lookup function but show me an error.

Regards,

Satish Kumar

[SivaMani]

@Satish_Kumar,

Please create the measure as a Calculated column with the same formula. Wherever we use calculated measure, it will return a single value. It expects aggregation function to return a value.

Thanks,

Siva

[Satish_Kumar]

@SivaMani

Thanks for replying.....

You want to me recreate the same column as a measure.

But why it shows me an error I did the same to lookup my Lastfy and it was done successfully.

Regards,

Satish

[SivaMani]

Is it a calculated measure or column?

[Satish_Kumar]

@SivaMani

Actually, i am not able to create last month as a measure.

And as you told me to do I tried but I think we cannot use the same formula to create the measure.

If I am wrong then please correct me.

Regards,

Satish 

[SivaMani]

@Satish_Kumar,

You requirement is,

Right?

[Satish_Kumar]

@SivaMani

Yes!!!!

But I have to make a lookup with another table also to demonstrate their values according to years and month.

Regards,

Satish Kumar

[SivaMani]

Use the Last Month DAX which you created earlier,

LM = LOOKUPVALUE(Testing[MonthName],Testing[MonthOrder],Testing[MonthOrder]-1)

It will work

[Satish_Kumar]

@SivaMani

Sorry!!

But it is not working.

Regards,

Satish

[SivaMani]

Create calculated column instead of measure.