have the difference between 2 dates dynamically

[LLJ1221]

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

[vicky_]

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)

[LLJ1221]

Hi @vicky_ ,

Thanks for your feedback.

I published to specify sue I susu in Direct Query mode and I know that I had already had problems with the "FirstDate" function because it was not supported in direct query mode

[vicky_ · Accepted solution]

Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.