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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.