Forum Discussion
Startofmonth() in Virtual Table
Trying using this instead
Eomonth( [value], -1) + 1
Super UserRemove the calculate to avoid context transition
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 ?- Deku
If 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,
