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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
DinaFlo
New Member

Fully Qualified Column error with Calendar Table

I'm working on a Measure to find my current data in the 'Funnel Data' table, based on the Current week (CurWeekOffset = 0) in the 'Calendar' table.

Current Admits = FILTER('Funnel Data', RELATED('Calendar'[CurWeekOffset] = 0))
 
The RELATED function is giving me a "Fully qualified column reference expected," but it seems like I am giving it a fully qualified column refence.
 
Does anyone happen to know what the issue might be?
I'm new to Power BI, and I'm working with student data, which functions differently than Sales data, so finding solutions for specific needs has been a challenge.
 
Thanks in advance!
Dina
1 ACCEPTED SOLUTION
johnt75
Super User
Super User

You just have a ) in the wrong place

Current Admits =
FILTER ( 'Funnel Data', RELATED ( 'Calendar'[CurWeekOffset] ) = 0 )

View solution in original post

2 REPLIES 2
DinaFlo
New Member

Ack.  Thank you!

johnt75
Super User
Super User

You just have a ) in the wrong place

Current Admits =
FILTER ( 'Funnel Data', RELATED ( 'Calendar'[CurWeekOffset] ) = 0 )

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.