Forum Discussion
Startofmonth() in Virtual Table
Trying using this instead
Eomonth( [value], -1) + 1
OK, THANKS,
last question,
I need to retrive a value from a table "f_Forecast Litros" .
I´m trying to use lookup value with the column @InicioMe (a column generated in my virtual table, but I can´t select it (similar to Value) I think its the same issue, the filter context but I don´t know how to solve this, can you help me please ?
Super UserIf you create a field with addcolumns, you cannot access it from another column in the same addcolumn expression. You would be able to access it if you were to iterate the virtual table with sumx or addcolumn.
What you can do is, instead of defining @InicioMe as a field, you can define it as a variable within @forecast mes
Addcolumns(
... ,
"Forecast mes"
Var @InicioMe = ....
Return
....
)
hi,
I accessed the field InicioMes from another addcolumn statment that I added as you suggested.
Now I can´t solve the Lookupvalue issue.
I need to filter the f_Forecast Litros table, but I got the following error.
Would you please check my measure ?
Thanks in adavance,
Hi FML
Regarding your issue with LOOKUPVALUE, you're likely running into a limitation because you're trying to use a column from a virtual table (like InicioMes) as the search value, which LOOKUPVALUE doesn't support directly especially when it's defined within the same row context or created on the fly.Instead of LOOKUPVALUE, try using CALCULATE with FILTER or TREATAS.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards