Forum Discussion
Count when Dates match between 2 columns
Hi Team,
I am working on a Power BI matrix visual and there is a challenging ask to calculate the count of dates matching between 2 columns and % for it.
Sample Data:
| Parent | Title | Column | London | Melbourne | Sydney | Dallas | Phoenix |
| Xyz | Title 1 | A | 4/7/2022 | 5/12/2022 | 2/28/2025 | 2/17/2024 | 3/31/2027 |
| Xyz | Title 1 | B | 5/12/2022 | 11/8/2023 | |||
| Xyz | Title 2 | A | 2/27/2024 | 9/6/2023 | 7/15/2023 | 5/12/2022 | 5/12/2022 |
| Xyz | Title 2 | B | 7/15/2023 | 8/12/2022 | |||
| Xyz | Title 3 | A | 11/8/2023 | 4/18/2026 | 1/30/2026 | 1/5/2026 | 5/9/2027 |
| Xyz | Title 3 | B | 11/8/2023 | 1/5/2026 | |||
| Xyz | Title 4 | A | 10/10/2026 | 5/9/2027 | 11/27/2025 | 6/30/2025 | 2/17/2024 |
| Xyz | Title 4 | B | 2/17/2024 | ||||
| Xyz | Title 5 | A | 3/31/2027 | 2/8/2028 | 2/8/2028 | 12/4/2027 | 2/1/2024 |
| Xyz | Title 5 | B | 2/8/2028 |
Color coded for easy reference to hightlight the dates matching:
I am trying to calculate the following for Parent Xyz,
1) COUNT(DATES) for Column A (excepted result is 20)
2) COUNT(DATES) for Column B (expected result is 8 )
3) Matching DATES % between Column A and Column B (expected result is 6/20 = 30%)
Power BI Experts, please weigh in your thoughts to create the measure(s) to solve this.
Thanks in advance!
1 Reply
- smpa01
Community Champion
rameshgopalan01 microsoft is yet to come up with a mechanism to convert jpg/png to tabular data inside power bi; till then any question with sample data and clearly stated desired output moves with lightning speed in this forum