Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
9 years ago
Solved

Writing a Condition

Here's a snapshot of my data:   I need a way to say whether or not an OrganizationName is considered CSP (IsCSP= CSP). However, each JobNum has multiple RateDesc, some rates are CSP and some are...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi bhmiller89,

     

    From your description, I create some sample data, you can create calculated columns like below:

     

    IsCSPNew = IF('Table3'[IsCSP]="CSP",1,0)

     

    OrgName = IF(CALCULATE(SUM(Table3[IsCSPNew]),ALLEXCEPT(Table3,'Table3'[TSMDepartment],'Table3'[OrganizationName],'Table3'[Domain Name],'Table3'[JobNum])),
                      "CSP",
                      "NotCSP"
                  )

     

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi bhmiller89,

 

From your description, I create some sample data, you can create calculated columns like below:

 

IsCSPNew = IF('Table3'[IsCSP]="CSP",1,0)

 

OrgName = IF(CALCULATE(SUM(Table3[IsCSPNew]),ALLEXCEPT(Table3,'Table3'[TSMDepartment],'Table3'[OrganizationName],'Table3'[Domain Name],'Table3'[JobNum])),
                      "CSP",
                      "NotCSP"
                  )

 

 

 

Best Regards,
Qiuyun Yu