Forum Discussion

DinaFlo's avatar
DinaFlo
New Member
3 years ago
Solved

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
  • You just have a ) in the wrong place

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

2 Replies

  • You just have a ) in the wrong place

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