Forum Discussion

Harry_01's avatar
Harry_01
Regular Visitor
2 years ago
Solved

How to fetch a Column from Directquery Table?

Hi Expert, I am facing an issue to fetched a column from Directquery Table(Created in Power Query 'Fields Count' ). I am using RELATED function to fetched [ColumnCount] column. But it is not working...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Harry_01 , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship.

    Please checkit once 

     

    if it still does not work you can use LOOKUPVALUE function as alternative

     

    Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

Harry_01 , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship.

Please checkit once 

 

if it still does not work you can use LOOKUPVALUE function as alternative

 

Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])

  • Harry_01's avatar
    Harry_01
    Regular Visitor
    2 years ago

    Hi bhanu_gautam, 

    Thanks for the suggestion. I am trying the LOOKUPVALUE but getting the below error.

     

    A single value for column 'MN ID' in table 'Referance Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

     

    When i am using YourTable'[KeyColumn].

    Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])