"Not a fully qualified column reference"

Hi bonjourposte 

In Power BI, when you encounter an error stating a column is not a "fully qualified column reference," it usually means that the DAX formula can't uniquely identify the column because:

1. Ambiguous Column Names: If you have columns with the same name across different tables, Power BI requires more information to understand which column you're referring to. Ensure you specify the table name along with the column name in your DAX formulas, like 'TableName[ColumnName]'.

2. Import Mode Limitations: In Import Mode, DAX functions like 'RELATED()', 'RELATEDTABLE()', and 'LOOKUPVALUE()' should work fine as long as relationships are properly defined between the tables in your data model. Ensure your table relationships are correctly set up. For instance, 'RELATED()' and 'LOOKUPVALUE()' work across related tables, and 'RELATEDTABLE()' is used to retrieve a table related to the current row context.

3. Syntax Errors: Sometimes, it's a simple matter of syntax errors or typos. Double-check your formula for any mistakes.

DirectQuery vs. Import Mode

DirectQuery mode has limitations on certain DAX functions and how data is manipulated. Before you switch to DirectQuery mode, make sure your DAX formula is not affected.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.