Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.
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)
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
Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |