Forum Discussion
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....
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