Startofmonth() in Virtual Table

[FML]

buen día, no puedo utilizar la función Startofmonth() con una columna de una tabla virtual, generada mediante crossjoin. Me pueden ayudar por favor ? gracias

[FML]

thanks for for answer, but it doesn't work !

[Deku · Accepted solution]

Trying using this instead

Eomonth( [value], -1) + 1

[FML]

Excellent Deku !!!! it works !!!

Can you explain me how it works and why endofmonth doesn´t ?

[v-nmadadi-msft]

Hi @FML,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Deku]

The time intelligence functions are funny and I try to stay away from them.

Alot of info here

[Deku]

Remove the calculate to avoid context transition

[FML]

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

....

)

[FML]

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,

[v-nmadadi-msft]

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