Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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
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.
Regards,
Satish
Yes!!!!
But I have to make a lookup with another table also to demonstrate their values according to years and month.
Regards,
Satish Kumar
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |