Forum Discussion

rameshgopalan01's avatar
rameshgopalan01
Regular Visitor
2 years ago

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:

 

ParentTitleColumn LondonMelbourneSydneyDallasPhoenix
XyzTitle 1A4/7/20225/12/20222/28/20252/17/20243/31/2027
XyzTitle 1B 5/12/202211/8/2023  
XyzTitle 2A2/27/20249/6/20237/15/20235/12/20225/12/2022
XyzTitle 2B  7/15/20238/12/2022 
XyzTitle 3A11/8/20234/18/20261/30/20261/5/20265/9/2027
XyzTitle 3B11/8/2023  1/5/2026 
XyzTitle 4A10/10/20265/9/202711/27/20256/30/20252/17/2024
XyzTitle 4B    2/17/2024
XyzTitle 5A3/31/20272/8/20282/8/202812/4/20272/1/2024
XyzTitle 5B 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's avatar
    smpa01
    Icon for Community Champion rankCommunity 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