Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

Two Data Source Connection as Created RelationShips

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.
  • Use Table.AddColumn with a custom generator function. That allows you to realize conditional joins.

1 Reply

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