Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

How to compare row by row text field with other fields to check similarity

Hello Experts,

    I am new to Power BI and stuck with one of my requirement. Below is my simplified table

resourcename   |  servertype |    start_date   |    Start_Time    |
    Abc                  dbo              06-06-2023       1:00:00 AM
    DBA                 dbo              06-06-2023       1:00:00 AM
    CDS                  ora              04-06-2023        3:00:00 AM

Below table is the requirement is to find concurrency issue, i.e. 2 diferrent resourcename should not have same date, same time & same servertype. So, in first 2 rows we can see the resourcename are differrent but rest all is same. So expectation is that it should  show 2 counts for 06-06-2023 as concurrency issue

 

Output expected:

  Start_date     | Concurrent issue |

  06-06-2023                    2

Could someone please suggest how can we derive this using DAX or Query Editor? 
NOTE: All fields are "text" datatype. If required I can change the datatype for date & time

Thanks in Advance

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

There is no magic formula. You would need to implement all checks manually, using SUMMARIZE and COUNTROWS.  OR - simply plop your data into a matrix visual and present that as a graphical solution to the questions.

 

If you want to be cute you can run a Pearson correlation across your data rows but that is better done outside of Power BI.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks @lbendlin  , Thanks for your suggestion. That helped me. I used the below formula and it worked for me

calculate(distinctcount(Table[resourcename]), ALLEXCEPT(Table, Table[servertype], Table[start_date], Table[Start_Time])

lbendlin
Super User
Super User

There is no magic formula. You would need to implement all checks manually, using SUMMARIZE and COUNTROWS.  OR - simply plop your data into a matrix visual and present that as a graphical solution to the questions.

 

If you want to be cute you can run a Pearson correlation across your data rows but that is better done outside of Power BI.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors