Two Data Source Connection as Created RelationShips

SIBI1998 — Fri, 04 Feb 2022 11:17:08 GMT

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.

Re: Two Data Source Connection as Created RelationShips

lbendlin — Sun, 06 Feb 2022 22:51:43 GMT

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