Two Data Source Connection as Created RelationShips

[SIBI1998]

Hi Team,

               I want an if condition for this Query for Two Data Source Connection as Created Relationships:

If TABLEAU_REPORT UNIQUE_1ST_TRD_DERIVATIVE'[CLIENT_ID] is greater than TABLEAU_REPORT APRILTARGET'[Derivative Traders].

Example : TABLEAU_REPORT UNIQUE_1ST_TRD_DERIVATIVE'[CLIENT_ID] is 100 , TABLEAU_REPORT APRILTARGET'[Derivative Traders] is 70.

Here I need 100-70=30 , the value 30 is Multiplied by 50

If TABLEAU_REPORT UNIQUE_1ST_TRD_DERIVATIVE'[CLIENT_ID] is less than TABLEAU_REPORT APRILTARGET'[Derivative Traders] Value is to be 0.

[lbendlin · Accepted solution]

Use Table.AddColumn with a custom generator function. That allows you to realize conditional joins.