Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Related Function Not Working

Hi There,   I am trying to call one column (Process NAME) which is placed in Custom_Tab Schedule Table  1-Many realtionship with BPASession table  . They both are joined on Process Name (Many To 1)...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi Anonymous 

 

  1. If you are yousing mixed storage mode (one table - import mode and another table - direct query mode) RELATED function will not work properly. make sure that you have same storage mode for both tables.
  2. Again if you want solution with different storage methods,  you can use LOOKUPVALUE function, this fuction may work better for mixed storage sceniories.
  3. Make sure that, there are no blank or null values in the Process Name column on the one side (Custom_Tab_Schedule). Even a single blank value can cause issues with the relationship.

Additionally if you need more info you refer to following acctepted solutions.

Solved: RELATED function not working - Microsoft Fabric Community

Solved: RELATED Function with a Direct Query Table - Microsoft Fabric Community

 

Thanks!