Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Countifs multtiple tables

Hi,   I have 2 tables an in total 5 columns for the countifs function Table 1                 Table 2  Name                   Name Date                     Date Handled Mail          I want t...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Anonymous,

     

    You could create a relationship of the two tables and create a calculated column with IF FUNCTION.

     

    Column =
IF (
    AND (
        'Table1'[Date] = RELATED ( 'Table2'[Date] ),
        'Table1'[Name] = RELATED ( 'Table2'[Name] )
    ),
    COUNT ( Table1[Handled Mail] ),
    BLANK ()
)

    If you need additional help, please share your data sample and your desired output.

     

    Best Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

I have 2 tables and 5 columns for the COUNTIFS

 

Table Mail          Table Telephone

Name                 Name

Date                   Date

Handled Mail     

 

I want a column in Table Telephone with the handled mail if there is a match between the columns Name and Date of both tables.

 

kinds regards