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.
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 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.
Is it a calculated measure or column?
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.
But I have to make a lookup with another table also to demonstrate their values according to years and month.
Use the Last Month DAX which you created earlier,
LM = LOOKUPVALUE(Testing[MonthName],Testing[MonthOrder],Testing[MonthOrder]-1)
It will work
Create calculated column instead of measure.
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.