Forum Discussion
SIBI1998
4 years agoHelper I
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
- lbendlinSuper User
Use Table.AddColumn with a custom generator function. That allows you to realize conditional joins.