Forum Discussion
DinaFlo
3 years agoNew 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.
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
Dina
You just have a ) in the wrong place
Current Admits = FILTER ( 'Funnel Data', RELATED ( 'Calendar'[CurWeekOffset] ) = 0 )