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])