Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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,
Solved! Go to Solution.
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
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |