Forum Discussion

neonguyen's avatar
neonguyen
Frequent Visitor
7 years ago
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...
Need Help
  • ZunzunUOC's avatar
    ZunzunUOC
    7 years ago

    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.

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

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.