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 find difference/Compare for date field between two rows in table in power BI

Hi Team, I need to identify the different values between rows in Power Bi and highlight the difference value. Below table shows actualstartdate && Estimated Effort has difference value marked as Red. Can you please any one can help on this how can we achieve it. ThanksinAdvance

issue.PNG

 

5 REPLIES 5
Anonymous
Not applicable

HI @Anonymous,

Since power bi data model tables do not contain row and column index, you need to add specific filters to lockdown row contents to calculate. I'd like to suggest you share the logic about records that they need to be highlighted then we can coding formula based on these rules.

For example: 

You need to highlight get the difference between first and last milestone records based on the project group.

For this scenario, you can use project name to find out records and extract the first and last one records to calculate.

Regards,

Xiaoxin Sheng

lbendlin
Super User
Super User

what about the first line and the third line? these have different values too?

Anonymous
Not applicable

we need to compare first row with second row if there we find difference then we need to highlight it,

similarly 2nd and 3rd row......

third and forth row are different too but you didn't highlight that ?

Anonymous
Not applicable

Milestone is diff right we need to compare milestone and project

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.