Forum Discussion

smishra99acres's avatar
smishra99acres
Helper I
1 year ago

Related function

Hi i have build a rleationship in two table now ehen i am trying to created related fucntion its saying column not exist or dont have any relationship. can any one please help me in thisi?
Need Help
Pragati11's avatar
Pragati11
Super User
1 year ago

Hi smishra99acres ,

Can you kindly add more details to your query please?

RELATED dax function is used when you are trying to create a calculation using two related tables. It will be nice to see a screenshot of your relationship between 2 tables along with the dax expression that is giving you error.

Please check the details on how RELATED dax function works in Power BI through the blog:

https://radacad.com/get-a-field-value-from-a-related-table-in-power-bi-dax-related-function-explained

Some guidelines around how to get your query answered properly on this forum:

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

  • smishra99acres's avatar
    smishra99acres
    Helper I
    1 year ago

    Using above one and in auto suggest box mobile no is coming when i tried to save it then  below msg appears.

    The column 'lead[Mobile No.]' either doesn't exist or doesn't have a relationship to any table available in the current context.

    Column data type is text in both and link is created with same column.