Forum Discussion
Solved
Need DAX for below logic
Hi Team, I need DAX for below logic. I have two tables 1. invoice 2.policy Invoice table: Inv No Role Polid INV1 Executive Pol1 INV2 Reprtesentative Pol2 Policy Table: ...
RadhakrishnaE - Follow the below steps:
Step 1: First create a relation between both thos tables using Policy ID.
Step 2: Then create a new calculated column like below:
New Role = IF(RELATED('Policy Table'[Primary])="Y",'Invoice Table'[Role] &" - Primary",'Invoice Table'[Role] &" - Additional")Step 3: You'll get the output like below. Also attaching my PBIX file for your reference.
RadhakrishnaE - Follow the below steps:
Step 1: First create a relation between both thos tables using Policy ID.
Step 2: Then create a new calculated column like below:
New Role = IF(RELATED('Policy Table'[Primary])="Y",'Invoice Table'[Role] &" - Primary",'Invoice Table'[Role] &" - Additional")
Step 3: You'll get the output like below. Also attaching my PBIX file for your reference.
Thank you Tahreem24 you gave me the exact answer.
