DAX Not Recognizing Column Names from Table Stored in Variable

JoseH16 — Sun, 15 Oct 2023 02:59:34 GMT

Hello,

I am experiencing an issue where DAX is not recognizing the column names from a table I have stored in a variable, and I am hoping someone might be able to assist.

Problem Description:

When referring to the columns of my table stored in the variable named "Arreglo," DAX throws an error saying "Cannot find name '[Monto]' or '[Año]'," and upon pressing enter, another message appears stating "Cannot find table 'Arreglo'."

The problem occurs in the following code segment:
VAR Monto =
CALCULATE( SUMX( Arreglo, Arreglo[Monto] ), FILTER( Arreglo, Arreglo[Año] = [Año actual] && Arreglo[Mes] = Mes ) )

DAX Code :

Any guidance or assistance on this matter would be greatly appreciated. Thank you in advance!

Re: DAX Not Recognizing Column Names from Table Stored in Variable

Jihwan_Kim — Sun, 15 Oct 2023 04:47:42 GMT

Hi,

I think the columns that you want to use inside the measure is virtually created in VAR above.

Please try using the column name without the table name.

topic DAX Not Recognizing Column Names from Table Stored in Variable in DAX Commands and Tips

DAX Not Recognizing Column Names from Table Stored in Variable

Problem Description:

DAX Code :

Re: DAX Not Recognizing Column Names from Table Stored in Variable