Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JoseH16
New Member

DAX Not Recognizing Column Names from Table Stored in Variable

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 :
Measure problem.png

 

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

1 REPLY 1
Jihwan_Kim
Super User
Super User

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.

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.