Forum Discussion

FML's avatar
FML
Regular Visitor
1 year ago
Solved

Startofmonth() in Virtual Table

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    
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Trying using this instead

     

    Eomonth( [value], -1) + 1

FML's avatar
FML
Regular Visitor
1 year ago

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,

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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