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 to count the number of handled mails if there s a match between the name and date columns of both Tables

 

Kind regards,

  • 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

2 Replies

  • 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

     

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    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