Forum Discussion
Solved
Create a column by formula IF
I have two tables as bellow: Deal History: Deal: Two tables have relationship by Deal History[Deal ID] = Deal[ID] And i want to create a column to know which deal have history = PT Pe...
Hi neonguyen , try with this code:
Check PT = IF(CALCULATE(COUNTROWS('Deal History');FILTER('Deal History';'Deal History'[Deal ID]=Deal[ID] && 'Deal History'[Stage_change]="PT Pending"))<>0;1;0)Remenber to change ";" per "," and disabled the count option.
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Kalpavruksh
Resolver I
Resolver IHi,
We believe the reason your logic fails is because the relationship between two tables is defined by a column of Deal ID in the Deal History table, which has multiple values i.e. multiple rows for Deal 1.
Kalpavruksh Technologies | Microsoft Gold Partner
Denmark | USA | India | Germany
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Denmark | USA | India | Germany
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.