Forum Discussion
Date Difference with max date - row date
Hi,
PF below Table, Need to calculate column based on the Logic field which i updated, Need to consider the max date in Table and to show the difference with current row like updated in Result column.
I have tried , instead of max date it comin 31-12-2023, not working. Anyone help
| Date | Logic(Max Date - row date) | result |
| 01-05-2023 | 05-05-2023 - 01-05-2023 | 4 |
| 01-05-2023 | 05-05-2023 - 01-05-2023 | 4 |
| 01-05-2023 | 05-05-2023 - 01-05-2023 | 4 |
| 01-05-2023 | 05-05-2023 - 01-05-2023 | 4 |
| 02-05-2023 | 05-05-2023 - 02-05-2023 | 3 |
| 03-05-2023 | 05-05-2023 - 03-05-2023 | 2 |
| 04-05-2023 | 05-05-2023 - 04-05-2024 | 1 |
| 05-05-2023 | 05-05-2023 - 05-05-2024 | 0 |
Thanks,
Hi Anonymous
If you want a calculated column, you can use
Column = VALUE(MAX([Date])-[Date])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
Anonymous Should be something like:
Column = ([Max Date] - [Date]) * 1.Hi Anonymous
If you want a calculated column, you can use
Column = VALUE(MAX([Date])-[Date])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
