topic Re: Custom Column in Developer

Custom Column

Anonymous — Mon, 28 Aug 2023 19:06:27 GMT

If Table 1 has a common feild as table two then bring third column from Table two in Table 1.

IF Table1(ID) = Table2(ID)

Than Return Table2(Name)

Not able to create direct relationship due to having indirect relationship between both the tables.

Re: Custom Column

SamInogic — Tue, 29 Aug 2023 06:34:23 GMT

Hi @Anonymous

You can use Lookup function in DAX expression as below,

column1 = Lookup(table2, Table2(ID), Table(1)ID, Table2(Name)

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

Re: Custom Column

Anonymous — Wed, 30 Aug 2023 06:23:45 GMT

Hi @Anonymous ,

According to your statement, I know there is no relationship between two tables. I suggest you to try code as below to achieve your goal.

Name from Table 2 = /*Workaround 1: If you have one name for one ID*/ CALCULATE ( MAX ( Table2[Name] ), FILTER ( Table2, Table2[ID] = EARLIER ( Table1[ID] ) ) /*Workaround 2: If you have multiple names for one ID CONCATENATEX(FILTER(Table2,Table2[ID] = EARLIER(Table1[ID])),Table2[Name],",")*/ )

Result is as below.

Best Regards,

Rico Zhou

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