Forum Discussion
have the difference between 2 dates dynamically
Hello,
I don't know if my problem has already been asked on the forum but I haven't found any answers.
I have the following table:
Transaction | Operation number | Operation number_1 | date operation |
1223 | 080 | 080 | 11/02/2023 |
1223 | 070 | 070 | 05/03/2023 |
1223 | 010 | 010 | 20/11/2022 |
1223 | 0200 | 0200 | 01/08/2022 |
The user can choose different operations through two filters (Operation number and Operation number_1) in order to obtain the difference in days between the 2 selected operations.
For example if the user filters on operation number = 080 and another filters on operation number_1 = 010, the calculation would be 02/11/2023 - 11/20/2022
How can I carry out this calculation using a Dax formula please?
Thanks
Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.
3 Replies
Please try the following:
dates selected = var OPNo = CALCULATE(FIRSTDATE('Table'[date operation]), ALLEXCEPT('Table', 'Table'[Operation number])) var OPNo1 = CALCULATE(FIRSTDATE('Table'[date operation]), ALLEXCEPT('Table', 'Table'[Operation number_1])) return DATEDIFF(OPNo, OPNo1, DAY)Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.
